REMOVEFILTERS DAX Function in Power BI

The REMOVEFILTERS DAX function is used to remove any filter context including visual, report, page level filters, slicer, from the specified table or columns we specified in the function. It cannot be used to create a calculated table.

DAX Syntax 1) REMOVEFILTERS(table) The parameter table specifies the table that we want to clear filters on. 2) REMOVEFILTERS(column[, column[, column[,…]]]) The parameter column specifies the column that we want to clear filters on. Please note all the column names must be from the same base table 3) REMOVEFILTERS() When used without any arguments, it clears filters from all columns of all tables in the current filter context.

Note: The REMOVEFILTERS DAX function does not return a table, it can be used the filter modifier in CALCULATE function not as a table expression. REMOVEFILTERS is an alias for ALL function in Power BI.

Example: Let’s create a measure with name “REMOVEFILTERS Measure”.

Here, we are using REMOVEFILTERS functions which removes any filter from the column(s) that we have specified in the function, we are using Country column, so we return the sum of all countries data.

DAX

The output of the above dax function is shown below:

Please note the sum 8738 is the sum of 10th Marks of all countries.

Here we are using a slicer to filter the visual even though the measure value is returned all country value.

But when I have added the Name field also with the measure, we can see that now the measure is filtered on the Name context because only filters coming from the Country field is not going to affect the measure.

And now if we want the measure is not affect by the Name field then we need to specify it in the REMOVEFILTERS function, as in the following Dax formula.

DAX

Note: If we want no column of the table is going to affect the measure values, then we can specify the entire table name, as specified in the following dax formula.
DAX REMOVEFILTERS Measure1 = CALCULATE(SUM(Sheet1[10th Marks]), REMOVEFILTERS(Sheet1))

REMOVEFILTERS is an alias for ALL but can only be used as a CALCULATE modifier (not as a table function).