Filled map shows incorrect numbers in tooltip

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 () )
)