Ignore Filter not working

[Anonymous]

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.

https://community.fabric.microsoft.com/t5/Desktop/Make-measure-ignore-specific-filter/m-p/670629#M32...

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:

AHT_Ignore_Type_Owner = CALCULATE(IFERROR((SUM('table'[WLHRS]) / SUM('table'[VOL]))*3600, "0"), All('table'[type]))

[vicky_]

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.

[Anonymous]

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.