ALL function for page filters

[CloudMonkey]

Hi,

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?

Thank you,

CM

[v-deddai1-msft]

Hi @CloudMonkey ,

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?

Best Regards,

Dedmon Dai

[CloudMonkey]

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]

Hi @CloudMonkey ,

But my test results are consistent with the document description, which is very strange：https://docs.microsoft.com/en-us/dax/all-function-dax

Best Regards,

Dedmon Dai

[camargos88]

@CloudMonkey ,

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

[Greg_Deckler]

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