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


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formula Reference Guide