Forum Discussion

Ramosdabo221's avatar
Ramosdabo221
Regular Visitor
4 years ago
Solved

Data quality check

Hello,
I'm creating a data quality dashboard at the moment and what i want to have is some kind of a visual that shows the amount of null values and whitespaces in a column.

 

I really dont know how to use the daxformula for this. Could anyone help please?

Kind regards,

Ramosdabos

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    I think the most easy thing for you to do is the following then:

     

    Make a card, add the column you want to count values for. Right click on the field and set the values to "Count"

     

    Add the same column as a filter to the card, here you can choose which values you want to count.

     

    /M_illum

     

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
    You could make a measure like this: blancs = COUNTBLANK(Table[Column])
     
    Create a card and add the measure as the value
     
    Cheers

    M_illum
    • Ramosdabo221's avatar
      Ramosdabo221
      Regular Visitor
      4 years ago

      Thanks for your reaction!
      Does this also count the field in my dateset that are empty with spaces?

      Kind regards,

      Ramosdabos

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I would deal with empty spaces in the query editor. This could be done by the trim function Text.Trim - PowerQuery M | Microsoft Docs 


    It removes extra spaces, and rows containing only a space will be counted as blancs

    • Ramosdabo221's avatar
      Ramosdabo221
      Regular Visitor
      4 years ago

      I dont want to edit the dataset or anything. I just want to visualize the state of the dataset. So i want to show in some card visuals 
      - the amount of rows

      - the amount of null values
      -the amount of empty values

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I think the most easy thing for you to do is the following then:

         

        Make a card, add the column you want to count values for. Right click on the field and set the values to "Count"

         

        Add the same column as a filter to the card, here you can choose which values you want to count.

         

        /M_illum