How to compare null to values in the same column

[Anonymous]

Hi, I have a column that has numbers and some fields are blanks, I want to compare the total numbers to the number of blank fields.

I filtered it not to show the blanks, but now how do i display the blanks in the chart ?

[FrankAT]

Hi @Anonymous 

I don't know what you are facing:

• If you want to calculate the number of values and the number of blanks you can do it like this
• 

• May be you want to show items with no data:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Sumanth_23]

hi @Anonymous  - you can add a calculated column to get the number of Blanks in the specified column

Please refer to the below screen grabs for reference

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[PaulDBrown]

@Anonymous 

Just add a 0 to your measure 

for example: sum of values = SUM(table[column]) + 0

you can then compare to values == 0