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

  1. Interviewer asks a DAX question
  2. Identify the concept: context, CALCULATE, iterator, time
  3. Give a one-line definition
  4. Show a short measure from the sample model
  5. Is there a common pitfall? Yes: Mention it and how to avoid it. No: Summarise the answer.
  6. 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, SAMEPERIODLASTYEAR

Example

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

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic