How does the ALLCROSSFILTERED function (DAX) work?
The ALLCROSSFILTERED function (DAX) clears all of the filters that have been used within a table from other tables across direct or indirect many-to-many relationships.
ALLCROSSFILTERED Formula Syntax
How do you use the ALLCROSSFILTERED function?
ALLCROSSFILTERED can be used to modify the CALCULATE function. It cannot be used as a table function.
ALLCROSSFILTERED removes all the filters on an expanded table, as well as on columns and tables that have been cross-filtered because of bidirectional cross-filters set on direct or indirect relationships connected to the expanded table.
Related Blog Posts
Related Support Forum Posts
Considerations when using the ALLCROSSFILTERED function
The ALLCROSSFILTERED function can only be used to clear out filters; it will not return a table.
Related Video Tutorials
Formula examples using the ALLCROSSFILTERED function
MEASURE FactInternetSales[TotalQuantity1] =
CALCULATE(SUM(FactInternetSales[OrderQuantity]), ALLCROSSFILTERED(FactInternetSales)) MEASURE FactInternetSales[TotalQuantity2] =
CALCULATE(SUM(FactInternetSales[OrderQuantity]), ALL(FactInternetSales)) EVALUATE
SUMMARIZECOLUMNS(DimSalesReason[SalesReasonName], “TotalQuantity1”, [TotalQuantity1], “TotalQuantity2”, [TotalQuantity2])
ORDER BY DimSalesReason[SalesReasonName]
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.