Solved: Deactivate Filter

weraste · ‎05-05-2020

Hello,

please is it possible to make a filter inactive for a measure?
For example, I want to make for the measure "Top3 Sales" the filter "Type".

Thanks for your help.

Greg_Deckler · ‎05-05-2020

Depends, try using ALLEXCEPT, ALL or REMOVEFILTERS

Follow on LinkedIn
@ 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!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎05-05-2020

Depends, try using ALLEXCEPT, ALL or REMOVEFILTERS

Follow on LinkedIn
@ 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!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Deactivate Filter