Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
joshua1990
Post Prodigy
Post Prodigy

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?

1 ACCEPTED SOLUTION
Alf94
Solution Supplier
Solution Supplier

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,

View solution in original post

1 REPLY 1
Alf94
Solution Supplier
Solution Supplier

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,

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.