ALLCROSSFILTERED Function (DAX)
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
ALLCROSSFILTERED(
<table>
)
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
Summarize with filtered measure
Filtering in one column and ignoring filter on another
Conditionally Filtering Out Data
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
DEFINE
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]