Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Remove Filter on all Pages in Measure

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?

Need Help
  • Alf94's avatar
    Alf94
    3 years ago

    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,

1 Reply

  • Alf94's avatar
    Alf94
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

    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,