DAX Interview Questions
Power BI · Interview & Certification
Theory
DAX questions in interviews test whether you understand evaluation context, not whether you memorised functions. The most common are: the difference between a calculated column and a measure; row context versus filter context; what CALCULATE does and what context transition is; SUM versus SUMX; ALL versus ALLEXCEPT versus REMOVEFILTERS versus ALLSELECTED; how to compute % of total, year-to-date and year-over-year; why to use DIVIDE instead of the / operator; and how RANKX handles ties.
A strong answer is short, correct and backed by an example from a model you know. For example: 'SUM adds a column; SUMX evaluates an expression per row and then sums, so SUMX(Sales, Sales[Qty] * RELATED(Products[Price])) works when no revenue column exists.' Be ready to write a measure on a whiteboard and to explain why a given measure returns the grand total on every row.
Why we use it
DAX is where candidates are separated. Clear answers to these core questions show you can build correct measures rather than copying formulas.
When to use it
Practise these after finishing the DAX sections. Answer out loud with the sample model, and for each question prepare one measure you could write from memory.
How it works
- Interviewer asks a DAX question
- Identify the concept: context, CALCULATE, iterator, time
- Give a one-line definition
- Show a short measure from the sample model
- Is there a common pitfall? Yes: Mention it and how to avoid it. No: Summarise the answer.
- Clear, example-backed answer
Syntax
Practice format for each question:
1. One-sentence definition
2. A tiny example from the Sales model
3. A gotcha or when not to use it
Core functions: CALCULATE, FILTER, ALL, ALLEXCEPT, REMOVEFILTERS, SUMX, RELATED, DIVIDE, RANKX, TOTALYTD, SAMEPERIODLASTYEARExample
Q: Why does my calculated column show 6,200 on every Customers row?
A: SUM(Sales[Amount]) in a column has row context but no filter context, so it sums everything. Use [Total Sales] or CALCULATE(SUM(Sales[Amount])) to trigger context transition → Asha 2,700.
Q: Write % of total by region.
A: % of Total = DIVIDE([Total Sales], CALCULATE([Total Sales], REMOVEFILTERS(Sales[Region]))) // North 51.6%
Q: Year-over-year growth?
A: YoY % = DIVIDE([Total Sales] - [Sales LY], [Sales LY]) with Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date]))Key points
- Explain context first; most DAX answers depend on it
- Back each answer with a measure from a familiar model
- Know SUM vs SUMX and ALL vs ALLEXCEPT vs ALLSELECTED
- Use DIVIDE to avoid divide-by-zero errors
- Be ready to debug a measure that returns the grand total