Forum Discussion
CountIf Per Row
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 , 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)
2 Replies
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)This worked, thank you very much!
