% Data Completeness Score

Question

Hi All,&nbsp;Firstly I have tried a number of suggested solutions to working it out but none are quiet getting me there.&nbsp;I would like to present to the end user a % of data completeness score. I have 38 columns of data with a fair few nulls spread throughout the data set.....sample of what I am dealing with if I was not clear&nbsp;VendorAddressContact NumberFirst NameSurnameVendor ABC100 Street name0568 870 734TomnullVendor DEF78 Street namenullSandraJones&nbsp;The completeness score will be presented in a matrix so it is a per row basis.....any suggestions?&nbsp;&nbsp;&nbsp;

anonymous · Answer

I have tried adding columns and calculating the nulls and "" from each row including newly added colums. Currently dealing with a small sample dataset of 10k....looking to expand to 100k's

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
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.&nbsp;If they are null values, =BLANK(), if they are text, ="null".
&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

% Data Completeness Score

Related content

Calculating Score Difference between oldest and newest score

Scoring overall completion

Refresh completed with warnings

Creating Fabric Eventstream via API: How to complete the KQL Data Connection configuration?

Refresh completed with warnings

Vendor	Address	Contact Number	First Name	Surname
Vendor ABC	100 Street name	0568 870 734	Tom	null
Vendor DEF	78 Street name	null	Sandra	Jones