DAX Function Guide

REMOVEFILTERS
Empty image or helper icon

Sam McKay

CEO & Founder

How does the REMOVEFILTERS 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?

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

Loading

Considerations when using the REMOVEFILTERS?

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

Loading

Formula examples using the REMOVEFILTERS

= 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 Courses

Loading