CountIf Per Row

[ZW]

Hi, I was hoping someone could help me with a CountIf equivilanet in Power BI. 

I would like to count the number of n/a's per row, to then formulate a percentage of how many data fields have been completed for each row.

Due to the format of data export, I cannot transpose the data into columns rather than rows.

Please see example data, any help would be greatly appreciated.

Thank you.

Name	Birthday	Nationality	Gender	Age	Occupation	Address	Number of N/A	Percentage Row Complete
Steve	22/04/1990	n/a	Male	31	Builder	Scotland
Alice	n/a	Irish	Female	n/a	n/a	Ireland
Bob	n/a	British	n/a	52	Teacher	n/a

[ZW]

This worked, thank you very much!

[amitchandak · Accepted solution]

@ZW , then you have to try a measure like

Divide(
countx(filter(Table, Table[Name] ="N/A"), [Name])
+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)