Tutorials › Power BI › DAX Introduction

DAX Introduction

What DAX is, how it works, and why it is the most important Power BI skill to master

Let me tell you something that took me longer than it should have to fully grasp: DAX is not Excel with a different syntax. The surface looks similar — functions, parentheses, column references. But the underlying logic is completely different, and if you approach DAX thinking it is just a fancier SUMIF, you will write formulas that give correct-looking but wrong results, and you will not know why. The concept that changes everything in DAX is called filter context. Every DAX measure is evaluated inside a filter context — the set of filters active at the moment the measure runs. That context comes from slicers the user selects, the row in a matrix visual, the column header, the page-level filters, the report-level filters. When I write SUM(Sales[Amount]), I am not saying "sum all sales." I am saying "sum sales in the current filter context" — which might mean Delhi, Q1, Electronics, or any combination the user has selected. Once that clicks, DAX becomes logical. CALCULATE() is simply a function that lets you modify the filter context before evaluating an expression. ALL() removes filters. SAMEPERIODLASTYEAR() shifts the date filter back one year. Every complex DAX pattern is just an answer to the question: what filter context do I need, and how do I create it? I have trained hundreds of analysts on DAX. The ones who succeed are the ones who stop thinking about cells and ranges and start thinking about tables and filter contexts. The transition usually takes two to three weeks of daily practice. After that, it becomes the most expressive calculation language you have ever used.
Anatomy of a DAX Measure
Total Sales = SUM(Sales[Amount])
Measure name
Total Sales
How it appears in Fields pane
DAX function
SUM()
200+ built-in functions
Table name
Sales
Always TableName[Column]
Column name
[Amount]
Square brackets required
Excel formula
=SUM(A2:A100)
Fixed range — breaks when rows are added
DAX measure
SUM(Sales[Amount])
Dynamic — responds to all filters

Example

Your first DAX measure
WHERE TO WRITE DAX:
  Modeling tab → New Measure
  OR right-click a table in Fields pane → New Measure

BASIC MEASURES:
Total Sales = SUM(Sales[Amount])
Order Count = COUNTROWS(Sales)
Average Order = AVERAGE(Sales[Amount])
Max Sale    = MAX(Sales[Amount])
Min Sale    = MIN(Sales[Amount])

HOW TO NAME MEASURES:
  Use clear, readable names with spaces
  ✓ Total Revenue
  ✓ Sales Last Year
  ✗ rev
  ✗ calc1

WHERE DO MEASURES LIVE:
  Measures appear in the Fields pane under the table
  you created them in (shown with a calculator icon 🔢)
  Best practice: create a dedicated "Measures" table
💡 Measures are evaluated in context — the same measure shows different results when filtered by Region, Year, or Product.

Key Points

  • ✓DAX measures are calculated on the fly — they respond to every filter, slicer, and visual
  • ✓Measures (dynamic) vs Calculated Columns (static) — use measures for almost everything
  • ✓Filter context: the set of filters active when a measure is evaluated — the key concept in DAX
  • ✓DAX functions are similar to Excel functions but work on entire table columns, not ranges
  • ✓Start every DAX journey with SUM, COUNT, AVERAGE, CALCULATE — master these four first

FAQ

Q: Is DAX similar to Excel formulas?
A: DAX syntax looks similar to Excel — functions, parentheses, commas. But the logic is different. Excel formulas work cell-by-cell. DAX formulas work on entire columns and respond to filter context. SUMIF in Excel becomes CALCULATE(SUM(...), FILTER(...)) in DAX. The transition takes 2–4 weeks of practice.
Q: Do I need to know SQL to learn DAX?
A: No — but SQL thinking helps. If you know SQL's WHERE clause, you will understand DAX's FILTER() function faster. If you know SQL GROUP BY, you will understand how DAX aggregates in visual context. They are different languages but share the concept of filtering and aggregating tabular data.

Practice Question

Which Power BI pane do you use to write a new DAX measure?

Related Topics

Measures vs Calculated ColumnsWhen to use a DAX measure vs a calculated column — a decision that affects performanceBasic DAX FunctionsSUM, COUNT, AVERAGE, MIN, MAX, DISTINCTCOUNT — the foundation of DAXCALCULATE — The Most Important DAX FunctionMaster CALCULATE to control filter context and build any business metric in Power BI