Forum Discussion
Ignore Filter not working
Hi,
I am trying to write measures that ignore certain filters on the page. This is necessary to compare (eg Forecast vs Actual). Unfortunatley I can't seem to get this to work.
I have tried writing a measure that keeps the filters, and a second measure that ignores certain filters, put each on a card, and try to get them to show different values (filtered vs unfiltered/partially filtered), but so far they keep showing the same filtered values.
I have tried the solutions in both of these posts, but they are not working.
Calculate( Sum( Table1.Amount) , All(Table1.Filter), All(Table2.Filter) )
and
https://community.fabric.microsoft.com/t5/Desktop/Make-measure-ignore-specific-filter/m-p/336870
It's dead simple, really. Use the ALL function to remove a filter on a specific column like this:
Measure = calculate(Expression,ALL(column-you-want-to-remove-filter))
That's it. ALL, used inside a CALCULATE expression, works like REMOVEFILTER.
How can I make my measure ignore a select filter on the page?
Here is my most recent attempt, trying to ignore the "Type" (and eventually, when it works, "Owner") filters on the page:
2 Replies
When you say filters, are you referring to slicer visuals? If so, you can disable the visual interactions between the slicer and target visual, rather than using DAX.
Otherwise, ALL() / REMOVEFILTERS() should allow you to ignore certain filters.
Hi Vicky,
I am using slicers. Though I would like to ignore certain ones at the measure level, rather than configure it for each visual that uses the measures. I believe I need to do it that way so that I can have, for example, a line chart with one line representing "forecast" and another line representing "actuals" - both of which are part of a "type" column. ALL() is not making any difference between a measure that accepts all slicer filtering, and one that uses ALL() to ignore "type" slicer. I will look into using REMOVEFILTERS() more to see if I can get that to work.
