A measure OR calculated column to work our how man cells have no data

[steambucky]

My project involves me working out poor our data is,  We would like to work out how much info has not being entered. We then want express this as percentage per row 

Example data:

Animal - Name - Cost - Date

Dog      Danny    $50  - 1/1/2018     =  0%    Empty

Dog        null      $50     null              =  50 % Empty

Dog        null      null     null              =  75%  Empty

I have played around with caluclated feilds and measures doing simple things but NOTHING like this.

All I can think is something like a variable -  like If Animal =null then Row Empty = +1,  and then repeat something like this for each cell. From the Row empty value i could write a foumula to convert it into a percentage easily enough but I am stumped on everything before that.   

Any ideas, pointers, or simple examples would be most welcome.

[Ormesome · Accepted solution]

I'd create a column

_HowManyAreBlank= IF(ISBLANK([ANIMAL]), 1, 0) + IF(ISBLANK([NAME]), 1, 0) + IF(ISBLANK([COST]), 1, 0) + IF(ISBLANK([DATE]), 1, 0)

This would allow you to create a measure that works for rows, groups, and filters.