Why DAX is the step after building your first visuals
Dragging fields onto a chart gets you simple totals. Real business questions, such as profit margin, growth versus last year or sales for one region only, need calculations. DAX is how you write them once and reuse them across every visual in a report.
It looks like Excel formulas, but it works on whole tables and responds to the filters on the report page. Understanding that one idea makes most DAX problems much easier.
Measures versus calculated columns
The first decision in almost every DAX task.
Measure
Calculated at the moment a visual needs it, using whatever filters are active, such as Total Sales for the selected month. Use measures for most numbers in a report.
Calculated column
Calculated once for every row when the data refreshes and stored in the table, such as a Price Band label for each product. Use it when you need a value per row to filter or group by.
Filter context
The filters coming from slicers, visuals and rows in a table. A measure gives a different result in each cell because each cell has a different filter context.
Row context
The current row when DAX evaluates a calculated column or an iterator such as SUMX. It is how DAX works row by row.
The DAX functions to learn first
These cover most beginner and interview tasks:
- SUM, AVERAGE, MIN and MAX – basic aggregations of a column.
- COUNTROWS and DISTINCTCOUNT – how many rows, and how many unique customers or orders.
- DIVIDE – a safe division that returns blank instead of an error when the denominator is zero, ideal for margins and ratios.
- SUMX – an iterator that calculates something row by row, such as quantity × price, then adds it up.
- CALCULATE – the most important DAX function: it evaluates an expression with changed filters, such as sales for one region only.
- FILTER and ALL – build a filtered table, or remove filters, often inside CALCULATE for shares of total.
- TOTALYTD and SAMEPERIODLASTYEAR – year-to-date totals and last-year comparisons, using a proper date table.
Write your first useful measures
Practise on any sales dataset with an orders table and a date table.
Create a date table
Build or import a calendar table, mark it as the date table and relate it to your orders. Time-intelligence functions rely on it.
Start with Total Sales
Write Total Sales = SUM(Orders[Sales]) and use it in a card and a chart by month.
Add a ratio
Write Profit Margin = DIVIDE([Total Profit], [Total Sales]) and format it as a percentage.
Use CALCULATE
Write a measure for one segment, such as sales in a single region, and compare it with the total in the same visual.
Add time intelligence
Write Sales LY with SAMEPERIODLASTYEAR, then a growth measure that divides the difference by last year's sales.
Quick answers about DAX in Power BI
Short answers to the questions analysts search for most.
What is DAX in Power BI?
DAX stands for Data Analysis Expressions. It is the formula language used in Power BI, Power Pivot and Analysis Services to create measures, calculated columns and calculated tables.
Is DAX hard to learn?
The basics are approachable, especially if you know Excel formulas. The harder part is understanding filter context and CALCULATE, which comes with practice on real reports.
What is the difference between a measure and a calculated column?
A measure is calculated on demand using the report's current filters and is not stored per row. A calculated column is computed for every row at refresh time and stored in the table.
Why is CALCULATE so important in DAX?
CALCULATE lets you change the filters a calculation uses, which is how you build comparisons such as one region versus total, this year versus last year, or a share of the overall figure.
Do data analyst interviews ask about DAX?
For Power BI roles, often yes. Expect questions on measures versus calculated columns, CALCULATE, and writing a simple year-on-year or percentage-of-total measure.
Go further with Power BI and reporting
See where Power BI sits in the syllabus, or read the guides that build on it.
Write five measures this week
Load a sample sales dataset into Power BI and write Total Sales, Profit Margin, a single-region CALCULATE measure, Sales Last Year and Year-on-Year Growth. Those five measures cover most of what beginner DAX interviews ask.

