Forum Discussion
Ramosdabo221
4 years agoRegular Visitor
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 h...
- Anonymous4 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
Anonymous
4 years agoNot applicable
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
4 years agoRegular Visitor
Thanks for your reaction!
Does this also count the field in my dateset that are empty with spaces?
Kind regards,
Ramosdabos