ALLCROSSFILTERED

Applies to: Calculated column Calculated table Measure Visual calculation

Clear all filters which are applied to a table.

Syntax

ALLCROSSFILTERED(<table>)

Parameters

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,