Opposite of ALLSELECTED (Respect matrix column and row filtering | Ignore slicer filtering)

[mmace1]

ALLSELECTED ignores the filters within a Matrix, but respects the filters coming from Slicers. 

e.g.  = CALCULATE(sum(amount),ALLSELECTED(FactTable)

What about the opposite:  Respects the filters within a matrix, but ignores the filters coming from Slicers? 

[edhans]

There isn't a function to do that that I am aware of, but you can tell the matrix to ignore the slicers via the Format/Edit Interactions button when the matrix is selected.

Or use ALL() to manually remove filters that the slicer is using.

[mmace1]

Thank,

I don't want the entire Matrix to ignore the slicers, just specific measures within the Matrix to ignore the slicers, so Edit Interactions won't work in this case.  

For using ALL. 

I have ~20 filters (this is a very exploratory-level project), that themselves come from 3 tables. 

How could I construct an ALL statmeent that would casue the measare to ignore all filters coming from those 3 tables?  I can put the FACT table in the ALL statement, but then I just end up removing the Matrix row filtering as well. 

[v-yiruan-msft]

Hi @mmace1 ,

Could you please provide some sample data and the formula of the specific measures which need to ignore the filter? And what's your final expect result?

Best Regards

Rena