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.
» 1 related function
Examples
-- Filter Litware/Red
EVALUATE
CALCULATETABLE (
SUMMARIZE ( 'Product', 'Product'[Category], 'Product'[Brand], 'Product'[Color] ),
Product[Brand] = "Litware",
Product[Color] = "Red"
)
-- Remove Red filter, as a result the filter is Litware only
EVALUATE
CALCULATETABLE (
CALCULATETABLE (
SUMMARIZE ( 'Product', 'Product'[Category], 'Product'[Brand], 'Product'[Color] ),
REMOVEFILTERS ( 'Product'[Color] )
),
Product[Brand] = "Litware",
Product[Color] = "Red"
)
| Category | Brand | Color |
|---|---|---|
| Home Appliances | Litware | Red |
| Category | Brand | Color |
|---|---|---|
| TV and Video | Litware | Silver |
| Home Appliances | Litware | Silver |
| Home Appliances | Litware | Blue |
| Home Appliances | Litware | White |
| Home Appliances | Litware | Red |
| TV and Video | Litware | Black |
| Home Appliances | Litware | Black |
| Home Appliances | Litware | Green |
| Home Appliances | Litware | Orange |
| Home Appliances | Litware | Pink |
| Home Appliances | Litware | Yellow |
| Home Appliances | Litware | Purple |
| TV and Video | Litware | Brown |
| Home Appliances | Litware | Brown |
| Home Appliances | Litware | Grey |
-- Filter Litware/Red
EVALUATE
CALCULATETABLE (
SUMMARIZE ( 'Product', 'Product'[Category], 'Product'[Brand], 'Product'[Color] ),
Product[Brand] = "Litware",
Product[Color] = "Red"
)
-- Remove all the filters from Product: as a result, both Litware and Red filters are removed
EVALUATE
CALCULATETABLE (
CALCULATETABLE (
SUMMARIZE ( 'Product', 'Product'[Category], 'Product'[Brand], 'Product'[Color] ),
REMOVEFILTERS ( 'Product' )
),
Product[Brand] = "Litware",
Product[Color] = "Red"
)
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
-
USERELATIONSHIP in Calculated Columns
USERELATIONSHIP lets you temporarily change which relationship is active. Even though USERELATIONSHIP is easy to work with in measures, it can be challenging and give you inaccurate results when used in calculated columns. In this article we describe the details… » Read more
-
Computing MTD, QTD, YTD in Power BI for the current period
This article describes how to use the DAX time intelligence calculations applied to the latest period available in the data, also known as the “current” period. » Read more
-
Filter context in DAX explained visually
This article describes the DAX filter context using a conceptual model based on a visual representation. » Read more
Related functions
Other related functions are:
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/removefilters-function-dax