Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
9 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 name (Distinct), and I hover over Nigeria, it is showing me the count = 1 instead of 0. Any advise?

 

Thanks,

Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 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

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 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