Returns all the rows in a table except for those rows that are affected by the specified column filters.
The name of an existing table.
A column whose filtering is to be retained. It can be part of the expanded table. A table of the expanded table can be specified, too.
This function removes the corresponding filters from the filter context. It does not materialize the resulting table when called directly in a filter argument of CALCULATE or CALCULATETABLE.
Remove filters from all the columns of the Customer table but City.
ALLEXCEPT ( Customer, Customer[City] )
Remove filters from all the columns of the expanded table Sales but City.
ALLEXCEPT ( Sales, Customer[City] )
Remove filters from all the columns of the expanded table Sales but Date table and City column.
ALLEXCEPT ( Sales, 'Date', Customer[City] )
Learn more about ALLEXCEPT 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
Using ALLEXCEPT versus ALL and VALUES
This article describes the semantic difference between ALLEXCEPT and the joint use of ALL and VALUES, showing practical examples of the different results in Power BI and SSAS 2016. » Read more
Expanded tables in DAX
Expanded tables are the core of DAX; understanding how they work is of paramount importance. This article provides a theoretical foundation of what expanded tables are, along with fundamental concepts useful when reading DAX code. » Read more
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/allexcept-function-dax