REMOVEFILTERS DAX Function (Filter)

Clear filters from the specified tables or columns.

Syntax

REMOVEFILTERS ( [<TableNameOrColumnName>] [, <ColumnName> [, <ColumnName> [, … ] ] ] )

Parameter	Attributes	Description
TableNameOrColumnName	Optional	The name of an existing table or column.
ColumnName	Optional Repeatable	A column in the same base table.

REMOVEFILTERS is an alias for ALL, but it can be used only as a CALCULATE modifier and not as a table expression like ALL .

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

Other related functions are:

Contributors: Alberto Ferrari, Marco Russo