DAX function
ALL — DAX function reference
Ignore filters on a table/column.
Syntax
dax
ALL(<table> | <column1> [, <column2>, …])
Examples
dax
CALCULATE(SUM(Sales[Amount]), ALL(Sales))
→ Grand total
dax
CALCULATE(SUM(Sales[Amount]), ALL(Sales[Region]))
→ Total across all regions, still filtered by the current Date/Product context
dax
DIVIDE([Sales], CALCULATE([Sales], ALL(Product)))
→ This product's share of total sales across all products
Common mistakes & gotchas
- The classic denominator for a percent-of-total measure.
- ALL(Table) clears filters from every column of that table; ALL(Table[Column]) clears only that column, leaving other filters (like Date or Category) intact — picking the wrong granularity is the most common percent-of-total bug.
- ALL does not respect slicers or page-level filters at all, even ones the user just clicked — use ALLSELECTED when the denominator should follow what's visibly selected.
Related DAX functions
From Filter context