Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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)
This worked, thank you very much!
@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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |