Forum Discussion

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 th...

Need Help

amitchandak
2 years ago
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/

amitchandak

Super User

2 years ago

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
Not applicable
2 years ago
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!

Forum Discussion

Measure ignoring slicer

Related content

Ignore Slicer in measure

Ignoring Date Slicer with measure

Power BI – YoY Measure Ignoring Product Filter but Respecting Slicers

DAX Measure ignore filter/slicer selection

Ignore slicer in measure