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]

Related Course Modules

DOWNLOAD

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.