Remove Filter on all Pages in Measure

[joshua1990]

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 · Accepted solution]

Hi @joshua1990

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,