DAX function
ALLEXCEPT — DAX function reference
Ignore all filters except listed.
Syntax
dax
ALLEXCEPT(<table>, <column1> [, <column2>, …])
Examples
dax
CALCULATE(SUM(Sales[Amount]), ALLEXCEPT(Sales, Sales[Region]))
→ A number
dax
CALCULATE(DISTINCTCOUNT(Sales[CustomerID]), ALLEXCEPT(Sales, Sales[Year]))
→ Distinct customers per year, ignoring region/product/channel filters
dax
VAR CategoryTotal = CALCULATE(SUM(Sales[Amount]), ALLEXCEPT(Sales, Product[Category])) RETURN DIVIDE(SUM(Sales[Amount]), CategoryTotal)
→ This row's share of its category total
Common mistakes & gotchas
- ALLEXCEPT(Sales, Sales[Region]) behaves like ALL(Sales) followed by re-applying only the Region filter — it also clears filters coming from related dimension tables (like Product or Date), not just columns physically on Sales itself.
Related DAX functions
From Filter context