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

If you could only learn one DAX function — and I strongly advise learning far more than one — it would be CALCULATE. Not because it is the most common (though it is). Because understanding CALCULATE deeply means understanding how DAX works at a fundamental level. Everything else in DAX is variation on the same theme. I have reviewed hundreds of Power BI files built by analysts of all experience levels. The files built by people who truly understand CALCULATE are clean, fast, and correct. The files built by people who cargo-cult formulas they found online without understanding CALCULATE are a mess — measures that give different numbers in different visuals, % of total calculations that never add up to 100%, year-over-year metrics that break when someone adds a new slicer. Here is the one-sentence explanation I give every analyst I train: CALCULATE evaluates an expression in a modified filter context. That is it. The first argument is what you are calculating. Every argument after that modifies the filter context in which you calculate it. CALCULATE(SUM(Sales[Amount]), Region = "Delhi") means: sum sales, but only in a context where Region is Delhi — regardless of what the slicer says. The moment this clicks, you stop guessing and start reasoning. You can look at any business question — "what percentage of this region's sales is this product?" — and immediately know: I need CALCULATE with ALL() on the dimension I want to remove. That clarity is worth more than knowing a hundred DAX functions by name.

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

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

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
  )

% 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