Measure ignoring slicer

[Anonymous]

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?

[amitchandak · Accepted solution]

@Anonymous , Try like

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

CALCULATE with and without FILTER- https://youtu.be/KDcmzwgPvXQ

http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/

[Anonymous]

Thank you for your prompt reply, that worked very well! I'll have a look at the video to understand why I need to do it that way, thanks again!