ALLCROSSFILTERED

Applies to: Calculated column Calculated table Measure Visual calculation

Clear all filters which are applied to a table.

Syntax

ALLCROSSFILTERED(<table>)

Parameters

Term	Definition
table	The table that you want to clear filters on.

Return value

N/A. See remarks.

Remarks

• ALLCROSSFILTERED can only be used to clear filters but not to return a table.

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

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]

Returns,

DimSalesReason[SalesReasonName]	[TotalQuantity1]	[TotalQuantity2]
Demo Event	60398
Magazine Advertisement	60398
Manufacturer	60398	1818
On Promotion	60398	7390
Other	60398	3653
Price	60398	47733
Quality	60398	1551
Review	60398	1640
Sponsorship	60398
Television Advertisement	60398	730

Note

There is a direct or indirect many-to-many relationship between FactInternetSales table and DimSalesReason table.