DAX Calculations
48 practice questions with explanations — 15 free to try
PassNova has 48 Microsoft PL-300 (Power BI) practice questions on DAX Calculations, each with a clear explanation. A 15-question taster is free with no sign-up; the full bank is part of PassNova Premium. Updated for 2026.
DAX Calculations: example questions & answers
3 worked examples with answers and explanations below. Try 15 Microsoft PL-300 (Power BI) questions free in the browser; the full 48-question DAX Calculations bank is part of PassNova Premium.
What is the key difference between a calculated column and a measure in DAX?
- AA calculated column is evaluated in filter context at query time, while a measure is computed once per row and stored in the model
- BA calculated column is computed row by row and stored in the model; a measure is computed at query time in filter context✓
- CBoth are identical and interchangeable
- DMeasures can only return text; calculated columns can only return numbers
Answer: A calculated column is materialised per row during refresh and consumes storage; a measure is evaluated dynamically at query time based on the surrounding filter context.
What is the primary purpose of the CALCULATE function in DAX?
- ATo evaluate an expression in a modified filter context✓
- BTo create a physical relationship between two tables so filters can propagate
- CTo join several text values together into a single string
- DTo sort a table descending
Answer: CALCULATE evaluates its expression after applying, removing, or overriding filters, making it the central function for changing filter context in DAX.
Which DAX function removes filters from a column or table so a calculation ignores the current filter context (commonly used for a percent-of-total)?
- ARELATED
- BEARLIER
- CALL✓
- DFILTER
Answer: ALL removes filters from the specified column(s) or table, returning all rows regardless of context, which is how you compute a stable denominator for percent-of-total measures.