Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Measure ignoring slicer

I have a measure that counts number of projects missing value in a column. When no filters are applied in slicers all is well, but when I apply a slicer filter the count doesn't work. I've checked the interactions and they are not disabled.

 

The measue looks like this

 

 

 

Antal projekt saknar RE =
CALCULATE ( DISTINCTCOUNT ( ProjektLime[LimeID] ), ProjektLime[RE] = "" )

 

 

 

 

This gives me the same result

 

 

 

Antal projekt saknar RE =
CALCULATE ( DISTINCTCOUNT ( ProjektLime[LimeID] ), ISBLANK(ProjektLime[RE]) )

 

 

 

Applying this slicer setting RE to 1020 should give me the result 0 (or (Blank) ) in the corresponding card, but it says 234...

 

I really don't understand why, can anyone help me out, please?

 

 

2 Replies