Tutorials › Power BI › CALCULATE — The Most Important DAX Function

CALCULATE — The Most Important DAX Function

Master CALCULATE to control filter context and build any business metric in Power BI

CALCULATE is the most important function in DAX. Almost every non-trivial DAX measure uses CALCULATE. It does one thing: evaluates an expression while modifying the filter context. In plain English: CALCULATE lets you answer questions like "What were sales in Delhi, regardless of what region is selected in the slicer?" or "What were sales in the previous year?" or "What is the sales for only Category = Electronics?" Every time you want to override or add to the current filter — you use CALCULATE.
How CALCULATE Modifies Filter Context
SUM(Sales[Amount])
Active filters (from slicer):
Region = Delhi ✓
Result: Delhi sales only
₹2,50,000
⚡
CALCULATE(SUM(...), ALL(Region))
Active filters (modified):
Region filter removed
Result: ALL regions
₹10,00,000
Common CALCULATE patterns
% of Total
CALCULATE(SUM(...), ALL(table))
Filter by value
CALCULATE(SUM(...), Region = "Delhi")
Last year
CALCULATE(SUM(...), SAMEPERIODLASTYEAR(...))
Remove filter
CALCULATE(SUM(...), ALL(column))

Syntax

CALCULATE(expression, filter1, filter2, ...)

expression  — any DAX measure or aggregation
filter1...  — one or more filter conditions that modify context

Examples

CALCULATE fundamentals
EXAMPLE 1 — Sales for a specific region (ignores slicer)
Delhi Sales = CALCULATE(SUM(Sales[Amount]), Sales[Region] = "Delhi")

EXAMPLE 2 — Sales for a specific category
Electronics Sales =
  CALCULATE(
    SUM(Sales[Amount]),
    Products[Category] = "Electronics"
  )

EXAMPLE 3 — Sales above ₹10,000
High Value Sales =
  CALCULATE(
    SUM(Sales[Amount]),
    Sales[Amount] > 10000
  )

EXAMPLE 4 — Count of orders from 2026
Orders 2026 =
  CALCULATE(
    COUNTROWS(Sales),
    YEAR(Sales[OrderDate]) = 2026
  )
💡 CALCULATE evaluates the expression FIRST, then applies the filters. The filters modify the context in which the expression runs.
CALCULATE with ALL — remove filters
% of Total Sales =
  DIVIDE(
    SUM(Sales[Amount]),
    CALCULATE(SUM(Sales[Amount]), ALL(Sales))
  )

What this does:
  Numerator:   SUM in current context (e.g., Delhi only)
  Denominator: SUM with ALL filters removed = grand total
  Result:      Delhi / Grand Total = 18%

ALL() removes filters from a table or column.
This is how you calculate "% of total" metrics.

ALLEXCEPT — remove all filters EXCEPT specific columns:
  Sales in Context vs Year Total =
    CALCULATE(
      SUM(Sales[Amount]),
      ALLEXCEPT(Date, Date[Year])
    )
  → Keeps year filter, removes region/category filters

Key Points

  • ✓CALCULATE is how you write conditional aggregations in DAX
  • ✓Filters in CALCULATE add to or replace existing filter context
  • ✓ALL() removes all filters from a table — used for "% of total" calculations
  • ✓CALCULATE with a boolean filter: CALCULATE(SUM(...), Table[Col] = "Value")
  • ✓Nested CALCULATE is allowed — outer filter context takes precedence

Common Mistakes

✗ Mistake: Using CALCULATE when a simple SUM would work
✓ Fix: Only use CALCULATE when you need to modify the filter context. SUM(Sales[Amount]) is cleaner than CALCULATE(SUM(Sales[Amount])) if no filter is needed.
✗ Mistake: Forgetting that CALCULATE filter arguments replace, not add to, existing column filters
✓ Fix: When you filter Sales[Region] = "Delhi" in CALCULATE, it replaces any existing Region filter from slicers. Use KEEPFILTERS() if you want to intersect instead of replace.

Practice Question

You want a measure that always shows total sales across ALL regions, regardless of which region is selected in a slicer. Which formula is correct?