DAX Function Guide

ALLCROSSFILTERED Function (DAX)
Empty image or helper icon

Sam McKay

CEO & Founder

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 Function (DAX) Formula Syntax

ALLCROSSFILTERED(
     <table>
)

How do you use the ALLCROSSFILTERED Function (DAX)?

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

Loading

Considerations when using the ALLCROSSFILTERED Function (DAX)?

The ALLCROSSFILTERED function can only be used to clear out filters; it will not return a table.  

Related Video Tutorials

Loading

Formula examples using the ALLCROSSFILTERED Function (DAX)

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 Courses

Loading