Forum Discussion
% Data Completeness Score
Hi All, Firstly I have tried a number of suggested solutions to working it out but none are quiet getting me there. I would like to present to the end user a % of data completeness score. I h...
Hi Anonymous ,
You want to count the number of rows with nulls and then get the percentage of the total that are nulls, right?
You could use the COUNT() function or COUNTROWS() to get the number of rows.
For example,
CALCULATE(COUNT([Contact Number]), FILTER(ALL('TABLE'), [Contact Number]=BLANK()))
Here you need to determine whether your null is a text type or a null value. If they are null values, =BLANK(), if they are text, ="null".
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.