REMOVEFILTERS DAX Function (Filter)
Clear filters from the specified tables or columns.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| TableNameOrColumnName | Optional |
The name of an existing table or column. |
| ColumnName | Optional Repeatable |
A column in the same base table. |
Remarks
REMOVEFILTERS is an alias for ALL, but it can be used only as a CALCULATE modifier and not as a table expression like ALL .
Related articles
Learn more about REMOVEFILTERS in the following articles:
-
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might display unexpected behaviors. » Read more
-
Mark as Date table
Tabular models (including Power BI) require marking the Date table as a date table to get appropriate results with time intelligence calculations. This article explains why this setting is required. » Read more
Related functions
Other related functions are:
Last update: Oct 26, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/removefilters-function-dax