Solved: Ignore slicer filter in measure

Anonymous · ‎09-20-2021

I have a Measure which is a result of 2 other measures:

Shortage= [ReaminingQTYbyPU]+[Diff]

How to ignore a slicer filter in this measure? Thnaks!

Greg_Deckler · ‎09-20-2021

@Anonymous Something like:

Shortage= CALCULATE([ReaminingQTYbyPU]+[Diff],REMOVEFILTERS('SlicerTable'[Column]))

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎09-20-2021

@Anonymous Something like:

Shortage= CALCULATE([ReaminingQTYbyPU]+[Diff],REMOVEFILTERS('SlicerTable'[Column]))

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎09-20-2021

@Greg_Deckler sometimes things are easier than you think. Thanks a lot!

Ignore slicer filter in measure