Dynamically Update DAX with Slicer

Hi all,

I find this forum a valuable resource and am hoping someone can assist me with the below problem.

I have a sample set of personal records, with some data and some n/a.

My goal is to show how complete these records are (as in, not showing n/a) in the form of a percentage. I have managed to achieve this with 2 columns. The first one counts the number of n/a and returns a percentage:

Count n/a Percentage =
DIVIDE (
COUNTX ( FILTER ( 'Table', 'Table'[Birthday] = "n/a" ), [Birthday] )
+ COUNTX ( FILTER ( 'Table', 'Table'[Nationality] = "n/a" ), [Nationality] )
+ COUNTX ( FILTER ( 'Table', 'Table'[Gender] = "n/a" ), [Gender] )
+ COUNTX ( FILTER ( 'Table', 'Table'[Age] = "n/a" ), [Age] )
+ COUNTX ( FILTER ( 'Table', 'Table'[Occupation] = "n/a" ), [Occupation] )
+ COUNTX ( FILTER ( 'Table', 'Table'[Address] = "n/a" ), [Address] ),
COUNTROWS ( 'Table' ) * 7
)

The second column calculates the reverse of this to show percentage complete

Percentage Complete = DIVIDE(100 - ('Table'[Count n/a Percentage]*100),100)

This works fine as seen below:

However, if I use Name as a slicer this percentage doesn’t change to show only the percentage complete in that row.

My ideal output would be this:

Any help would be greatly appreciated.

Thank you