Forum Discussion

asewastianiuk's avatar
asewastianiuk
New Member
3 years ago

Ignore Filters on All Pages

Hi Everyone! I have a report that consists of 50 pages. There are report level filters applied (under Filters on All Pages). Now I have a request to add a new page or a visual that must ignore the report level filters. Is there a way to do that without moving my report filters to page filters 50 times?

Need Help
Tips and Tricks

1 Reply

  • rubayatyasmin's avatar
    rubayatyasmin
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi, asewastianiuk 

    I think Edit interaction will not work in this scenario. But can try it out for once. 

    If that doesn't work. you might need to create new measures using the ALL function. for example:

     

    Sales = Calculate([Measure],All(Table)) or 

    Total Sales = CALCULATE(SUM([Sales]), ALL('Table'[Category])) (assuming you want to remove category columns filter)

     

    Here is the documentation. https://learn.microsoft.com/en-us/dax/all-function-dax

     

    Please note that using the ALL function can result in large amounts of data being loaded into memory, so use it sparingly, especially if you're working with large datasets.

    Did this post help? If yes, hit 👍 and accept this answer as a solution.