Why is % yield in a purification table measured using activity instead of total protein?
Because total protein includes other proteins than the one desired.  

"% yield" is expressing how much of the enzyme desired was actually recovered.