Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

 

VendorAddressContact NumberFirst NameSurname
Vendor ABC100 Street name0568 870 734Tomnull
Vendor DEF78 Street namenullSandraJones

 

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

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
    Anonymous
    Not applicable
    4 years ago

    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.