Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
8 years ago
Solved

Color Saturation/ Count

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 ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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