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.
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.
Solved! Go to 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.
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.
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |