ALL function for page filters

Question

Hi,&nbsp;From my tests I think that the ALL function clears filters for cross-filtering visualisations but it does not clear page level filters (the filters listed under the "Filters on this page" heading). Please can someone confirm whether I am correct? Also please can someone tell me if there is a function that escapes all filters including the page level filters?&nbsp;Thank you,&nbsp;CM

greg_deckler · Answer

You are correct and I do not know of a work-a-round.

camargos88 · Answer

Anonymous&nbsp;,&nbsp;&nbsp;https://docs.microsoft.com/en-us/dax/all-function-dax

v-deddai1-msft · Answer

Hi Anonymous&nbsp;,&nbsp;Based on my test, ALL function will clear all filter for cross-filtering visualizations and page level filters. Would you please show us how you test?&nbsp;Best Regards,Dedmon Dai

anonymous · Answer

Sorry Dedmon the database has confidential information in it, which is usually the problem on here. It would be amazing if it was possible to anonymise the data with a click of a button.

v-deddai1-msft · Answer

Hi Anonymous&nbsp;,&nbsp;But my test results are consistent with the document description, which is very strange：https://docs.microsoft.com/en-us/dax/all-function-dax&nbsp;Best Regards,Dedmon Dai

Forum Discussion

ALL function for page filters

5 Replies

Related content

Page Level filter for different groups

Caclulate function over riding filter?

filter function

Filter on page 2 and page 1 all data

Tooltip page