% Data Completeness Score

[Anonymous]

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 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

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

The completeness score will be presented in a matrix so it is a per row basis.....any suggestions?

[Anonymous]

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.

[Anonymous]

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