Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix counting blank values in table

Hi!  I'd like to count all blank values in all columns in a data table and show them in a matrix, rows being the column names and one column showing the number of blanks in each column.    Is th...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    You can try the Power Query as in the video below.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous best approach would be to unpivot your table and then one measure can take care of this. To unpivot, go to Transform Data

 

add index column

select index column

right click, select unpivot other columns

 

you will have two new columns, Attribute and Value

 

and you can use COUNTBLANK() DAX to count blanks and on table visual add Attribute column and Measure and you will get the result.

 

Would appreciate Kudos 🙂 if my solution helped.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you for the solution. 

    Looks like this could work for projects using "Import", but I'm having difficulties as I'm using Direct Query (forgot to mention in my post).