Selective Removing of Page level Filters

[Bry2k]

Hello,

I've inheritied a PowerBI project.

On the Dashboard Tab, there are multiple filters effecting calculations across all the elements in the tab.

I would like to add a calculation which excludes one filter but keeps all the other filters that have been applied.

Cheers,

[johncolley]

Hi @Bry2k , you could also use Edit Iteractions to make sure the one filter doesn't apply to your new calculation: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=po... 

[Anonymous]

Hi @Bry2k,

Did the above suggestion help with your scenario? if that is the case, you can consider Kudo or Accept the suggestion to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi

Depending on the measure you can use either the REMOVEFILTERS() or the ALL() function to remove filters from the filter contex. Something like this:

CALCULATE(
    [Measure],
    --below the column you want to remove the filter
    ALL('Table'[column])
)

Bellow some documentation on both functions:

https://docs.microsoft.com/en-us/dax/removefilters-function-dax

https://docs.microsoft.com/en-us/dax/all-function-dax