ALL vs. ALLCROSSFILTERED

Hi Anonymous 

They all clear all filters which are applied to a table.

But ALLCROSSFILTERED(<table>) can only be used to clear filters but not to return a table.

See more details here:

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

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

 

Here is an example

Measure = SUM(Table1[sale])

Measure 2 = CALCULATE(SUM(Table1[sale]),ALL(Table2))

Measure 3 = CALCULATE(SUM(Table1[sale]),ALLCROSSFILTERED(Table2))

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.