ALLEXCEPT

ALLEXCEPT Removes all context filters in the table except filters that have been applied to the specified columns.


Syntax

ALLEXCEPT(table,column[,column[,…]])

Parameters

Table – The table over which all context filters are removed, except filters on those columns that are specified in subsequent arguments.

Column – The column for which context filters must be preserved.

Return Value

A table with all filters removed except for the filters on the specified columns.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Filter Functions / ALLEXCEPT