Forum Discussion

dc189's avatar
dc189
Icon for Helper II rankHelper II
9 years ago
Solved

Filled map shows incorrect numbers in tooltip

Hello,

 

I have a clustered column chart and a filled map on my dashboard. The bar chart shows the correct number of stores that opened and closed in the past 5 years but the tooltip in the map does not show the same numbers. What might be going wrong?

 

I am happy to share a pbix file but I don't see an icon in which to upload the file.

 

Any timely help would be greatly appreciated! Thank you!

Need Help
  • Sean's avatar
    Sean
    9 years ago

    dc189

    Okay yes the problem is COUNT does not count blanks while DISTINCTCOUNT does

    To illustrate what's happening look at the picture

    I've written all Measures (and simulated your Page Level filters with Slicers)

     

    So you've dragged the Store Opened field and you selected Disctinct count

    it is adding 1 to the 5 because all stores that were closed have a blank Store Opened field

    NOTE you are not performing any Status Check when doing this count because you are counting the Store Opened field

    and because you are doing a distcinct count all closed stores will count as 1 as their Store Open fields will be blank

     

    Hope this helps and makes sense! :smileyhappy:

     

    Here are the measures for you to test and see

     

    CountDistinct Stored Opened = 
    DISTINCTCOUNT('Sheet1 (2)'[Store Opened])

    CountDistinct Stored Opened No Blanks =
    CALCULATE (
        DISTINCTCOUNT ( 'Sheet1 (2)'[Store Opened] ),
        FILTER ( 'Sheet1 (2)', 'Sheet1 (2)'[Store Opened] <> BLANK () )
    )

     

     

5 Replies