Forum Discussion
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?
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/
2 Replies
- amitchandakSuper User
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/
- AnonymousNot applicable
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!