topic Remove Filter on all Pages in Measure in DAX Commands and Tips

Remove Filter on all Pages in Measure

joshua1990 — Thu, 13 Apr 2023 13:09:20 GMT

Hi experts!

I have a report with multiple visuals. To make it as easy as possible to maintain this report, I have some filters on "Filters on all pages".

Now I have 1 matrix visual with 1 measure where I would like to disable this filter. But how?

It is a simple SUMX function like this:

MIN = SUMX ( VALUES ( 'Attributes'[Article] ), MIN ( [Budget], [Sales] )

Do I need a CALCULATE + ALL or ALLEXPECT?

Alf94 — Thu, 13 Apr 2023 14:02:02 GMT

I think the best practice here would be the following:

MIN = SUMX( VALUES ( 'Attributes'[Article] ), CALCULATE( MIN ( [Budget], [Sales] ), REMOVEFILTERS ( Table[Column] ) ) )

where "Table[Column]" is the column you use in your filter on all pages. Let me know if this works.

If this measure works, please mark my answer as a solution to help people with the same question as you in the future.

Best,