REMOVEFILTERS

Applies to: Calculated column Calculated table Measure Visual calculation

Clear filters from the specified tables or columns.

Syntax

REMOVEFILTERS([<table> | <column>[, <column>[, <column>[,…]]]])

Parameters

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

Return value

N/A. See remarks.

Remarks

  • REMOVEFILTERS 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 1

DAX query

DEFINE
MEASURE FactInternetSales[TotalSales] = SUM(FactInternetSales[SalesAmount])
MEASURE FactInternetSales[%Sales] = DIVIDE([TotalSales], CALCULATE([TotalSales],REMOVEFILTERS()))

EVALUATE
    SUMMARIZECOLUMNS(
      ROLLUPADDISSUBTOTAL(DimProductCategory[EnglishProductCategoryName], "IsGrandTotal"),
      "TotalSales", [TotalSales],
      "%Sales", [%Sales]
    )
ORDER BY
  [IsGrandTotal] DESC, [TotalSales] DESC 

Returns

DimProductCategory[EnglishProductCategoryName] [IsGrandTotal] [TotalSales] [%Sales]
Row1 True 29358677.2207 1
Bikes False 28318144.6507 0.964557920570538
Accessories False 700759.96 0.023868921434441
Clothing False 339772.61 0.0115731579950215

Example 2

DAX query

DEFINE
MEASURE FactInternetSales[TotalSales] = SUM(FactInternetSales[SalesAmount])
MEASURE FactInternetSales[%Sales] = DIVIDE([TotalSales], CALCULATE([TotalSales],REMOVEFILTERS(DimProductSubcategory[EnglishProductSubcategoryName])))

EVALUATE
    SUMMARIZECOLUMNS(
      DimProductCategory[EnglishProductCategoryName],
      DimProductSubcategory[EnglishProductSubcategoryName],
      "TotalSales", [TotalSales],
      "%Sales", [%Sales]
    )
ORDER BY
  DimProductCategory[EnglishProductCategoryName] ASC,
  DimProductSubcategory[EnglishProductSubcategoryName] ASC

Returns

DimProductCategory [EnglishProductCategoryName] DimProductSubcategory [EnglishProductSubcategoryName] [TotalSales] [%Sales]
Accessories Bike Racks 39360 0.05616759
Accessories Bike Stands 39591 0.05649723
Accessories Bottles and Cages 56798.19 0.08105228
Accessories Cleaners 7218.6 0.0103011
Accessories Fenders 46619.58 0.06652717
Accessories Helmets 225335.6 0.3215589
Accessories Hydration Packs 40307.67 0.05751994
Accessories Tires and Tubes 245529.32 0.35037578
Bikes Mountain Bikes 9952759.564 0.35146228
Bikes Road Bikes 14520584.04 0.51276608
Bikes Touring Bikes 3844801.05 0.13577164
Clothing Caps 19688.1 0.05794493
Clothing Gloves 35020.7 0.10307099
Clothing Jerseys 172950.68 0.5090189
Clothing Shorts 71319.81 0.20990453
Clothing Socks 5106.32 0.01502864
Clothing Vests 35687 0.10503201