ALLCROSSFILTERED DAX Function (Filter)
Clear all filters which are applied to the specified table.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| TableName |
The table that you want to clear filters on. |
Remarks
ALLCROSSFILTERED can be used only as a CALCULATE modifier and cannot be used as a table function.
ALLCROSSFILTERED removes all the filters on an expanded table (like ALL) and on columns and tables that are cross-filtering the table argument because of limited (weak) relationships and/or bidirectional cross-filters set on relationships directly or indirectly connected to the expanded table.
Examples
ALLCROSSFILTERED removes the filter from the ColorGroups table that reaches Product through a limited relationship (many-to-many cardinality):
DEFINE
MEASURE Product[#Prods] =
COUNTROWS ( 'Product' )
MEASURE Product[#AllProds] =
CALCULATE ( [#Prods], ALL ( 'Product' ) )
MEASURE Product[#AllCrossProds] =
CALCULATE ( [#Prods], ALLCROSSFILTERED ( 'Product' ) )
EVALUATE
ADDCOLUMNS (
VALUES ( ColorGroups[Group] ),
"#Prods", [#Prods],
"#AllProds", [#AllProds],
"#AllCrossProds", [#AllCrossProds]
)
| Group | #Prods | #AllProds | #AllCrossProds |
|---|---|---|---|
| 2009-01-01 | 135 | 135 | 2,517 |
| 2010-01-01 | 236 | 236 | 2,517 |
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Renato Lira
Microsoft documentation: https://docs.microsoft.com/en-us/dax/allcrossfiltered-function-dax