Removes all context filters in the table except filters that have been applied to the specified columns.
ALLEXCEPT (<table>, <column>, [<column>] …)
|Sr.No.||Parameter & Description|
The table over which all context filters are removed, except filters on those columns that are specified in subsequent arguments.
One or more columns that are specified for which context filters must be preserved.
For the ALLEXCEPT function, the first argument must be a reference to a base table. All the subsequent arguments must be references to base columns in that table.
You cannot use table expressions or column expressions with the ALLEXCEPT function.
A table with all filters removed except for the filters on the specified columns.
ALLEXCEPT function is not used by itself, but serves as an intermediate function that can be used to change the set of results over which some other calculation is performed.
You can use ALLEXCEPT function if you want to remove the filters on many, but not all, columns in a table.
= CALCULATE (COUNTA (Results[Medal]), ALLEXCEPT (Hosts, Hosts[City]))
The values in Medal column in the Results table are counted with all the filters removed, except for the filters on the Column City in the Hosts table.
26 Lectures 4.5 hours