Ignore the filters applied in Filters on all pages in the DAX measure

[anushak2207]

I have a Filter on Filter on all pages, Fiscal Quarter = FY2024-Q1.
I also want to have a table visual where the PR% by Fiscal quarter. But due to the existence of All page filter on Fiscal quarter I am not getting the expected result. it always filters by the page level filter.
My expected result should be :

Attaching the sample PBIX file. 
I have tried with ALL, ALLSELECTED, REMOVEFILTERS and also ALLEXCEPT. None of them worked as expected. 
Kindly help on this issue.
PBIX file is available here:
https://github.com/anushak2207/PBI/blob/main/Ignore%20Quarter%20filter.pbix

Thank you

[Anonymous]

Hi @anushak2207,

Have you solved your problem?

I agree with speedramps that there is no OOTB way to remove a filter on all pages for just one visual or jsut one page.

You could try the workarounds @speedramps mentioned, and mark it as the answer if it works on your side.

Thanks for your cooperation.

Regards,

Qi

[speedramps]

There is no "out of the box" method removinG a filter on all pages for just one visual or jsut one page.

There are 3 work arround options:-

Apply a hidden slicer to one page and then copy , paste and sync the slicer all all pages  except your special page.

Create duplicate tables, and only apply the filter to one table

Create two reports using the same dataset. Use the filter in one report but no the other report.

Then include both reports in an App.

You can learn about apps here

https://learn.microsoft.com/en-us/power-bi/consumer/end-user-apps

Sorry if this is not the answer you want, but it is an answer. What you want is not poosible.

Please click thumbs up and accept solution