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

FILTER-CONTEXT

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

Filtering By Fiscal Or Financial Year Months & Quarters In Power BI

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

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formula Reference Guide