How does the REMOVEFILTERS function (DAX) work?
The REMOVEFILTERS function (DAX) clears filters from the specified tables or columns.
REMOVEFILTERS Formula Syntax
[<table> | <column>[, <column>[, <column>[,…]]]]
How do you use the REMOVEFILTERS function?
This function is useful and it does exactly what its name suggests. Its purpose is to act as a table filter parameter inside CALCULATE().
The REMOVEFILTERS can only be used to clear filters but not to return a table.
Related Blog Posts
Related Support Forum Posts
Considerations when using the REMOVEFILTERS function
When you use REMOVEFILTERS with no arguments, you ignore filters from the entire data model.
In a sense, REMOVEFILTERS is to ALL what RELATEDTABLE is to CALCULATETABLE: an alias with reduced functionality that can make your code more readable, which is always a good thing.
Related Video Tutorials
Formula examples using the REMOVEFILTERS function
= SUM(FactInternetSales[SalesAmount]) MEASURE FactInternetSales[%Sales] = DIVIDE([TotalSales], CALCULATE([TotalSales],REMOVEFILTERS()))
= CALCULATE( [Total Sales], REMOVEFILTERS(Products[Colour], Products[Category])
= SUM(FactInternetSales[SalesAmount]) MEASURE FactInternetSales[%Sales] = DIVIDE([TotalSales], CALCULATE([TotalSales],REMOVEFILTERS(DimProductSubcategory[EnglishProductSubcategoryName])))
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.