REMOVEFILTERS Function (DAX)

How does the REMOVEFILTERS function (DAX) work?

The REMOVEFILTERS function (DAX) clears filters from the specified tables or columns.

REMOVEFILTERS Formula Syntax

REMOVEFILTERS (
     [<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

Today vs Yesterday
Confusion in using “Thin and Long Fact Table”
Calculating days in stock for vehicles

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

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

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.