Color Saturation/ Count

[abukapsoun]

Hi,

Need your kind help again,

I have the following table

Country   Name

Sudan       X

Sudan       Y

Sudan       Z

Nigeria     (null)

When I use a map with color saturation count of name (Distinct), and I hover over Nigeria, it is showing me the count = 1 instead of 0. Any advise?

Thanks,

[v-qiuyu-msft · Accepted solution]

Hi @abukapsoun,

DISTINCTCOUNT function counts the number of different cells in a column of numbers, it will not ignore the null values. In your scenario, you can try to create a measure:

Measure 2 = var CountIgnoreBlank=CALCULATE(DISTINCTCOUNT(Table1[Name]),FILTER('Table1','Table1'[Name]<>BLANK()))
return
IF(CountIgnoreBlank=BLANK(),0,CountIgnoreBlank)

Then place this measure to Color Saturation box.

Best Regards,
QiuyunYu