ALLEXCEPT

ALLEXCEPT removes all the filters of a table, except those on the specified columns. It is used to compute a total per grouping level, for example the total of a category whatever product is displayed, while keeping the desired filter.

Example

CA catégorie = CALCULATE([CA], ALLEXCEPT(Produits, Produits[Catégorie]))

Related concepts

The whole glossary