Calculated Column vs Measure in Power BI: When to Use Each
Which TWO of the following are valid reasons to use a calculated column instead of a measure in Power BI? (Select exactly two.)
Quick Answer
The answer is that you need to use the value as a filter or slicer, as calculated columns are evaluated row by row and physically stored in the model, making them available for use in relationships and slicers, whereas measures are evaluated at query time and cannot define relationships between tables. This distinction is critical because calculated columns become part of the data model, allowing them to appear in the Filters pane and be used as slicer values, while measures only return dynamic aggregations and cannot serve as static filter criteria. On the Microsoft Power BI Data Analyst PL-300 exam, this concept often appears as a trap where candidates confuse row-level calculations with dynamic aggregations; a common memory tip is “columns are static, measures are dynamic.” Remember: if you need to slice or filter by a value, use a column; if you need to aggregate on the fly, use a measure.
⚠ Common exam trap
It's easy for candidates to confuse the static nature of calculated columns with the dynamic behavior of measures, incorrectly assuming that calculated columns can perform dynamic aggregations or running totals that respond to slicer selections.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
You need to use the column in a relationship.
Calculated columns are evaluated row by row and stored in the model, making them available for use in relationships. Measures, in contrast, are evaluated at query time and cannot be used to define relationships between tables in Power BI.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
You need to use the column in a relationship.
Why this is correct
Relationships require columns, not measures.
- ✗
You need to create a hierarchy for drill-down.
Why it's wrong here
Hierarchies can use calculated columns, but measures are not needed for hierarchies.
- ✗
You need to perform a dynamic aggregation that changes with filters.
Why it's wrong here
Measures are designed for dynamic aggregation.
- ✗
You need to calculate a running total.
Why it's wrong here
Running totals are often better as measures using DAX like CALCULATE and FILTER.
- ✓
You need to use the value as a filter or slicer.
Why this is correct
Measures cannot be used as slicers; columns can.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 217-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on PL-300
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Drag and drop the steps to create a calculated column in Power BI Desktop into the correct order.
medium- ✓ A.Step 1: Select the table. Step 2: Click New Column. Step 3: Write the DAX formula.
- B.Step 1: Click New Column. Step 2: Select the table. Step 3: Write the DAX formula.
- C.Step 1: Write the DAX formula. Step 2: Select the table. Step 3: Click New Column.
- D.Step 1: Select the table. Step 2: Write the DAX formula. Step 3: Click New Column.
Why A: Creating a calculated column involves selecting the table, using the New Column button, and writing a DAX expression that evaluates row by row.
Variation 2. Drag and drop the steps to create a calculated table in Power BI Desktop using DAX into the correct order.
medium- ✓ A.Navigate to the Modeling tab, click New Table, enter DAX expression in the formula bar, press Enter.
- B.Navigate to the Modeling tab, enter DAX expression in the formula bar, click New Table, press Enter.
- C.Navigate to the Modeling tab, click New Table, press Enter, enter DAX expression in the formula bar.
- D.Click New Table, navigate to the Modeling tab, enter DAX expression in the formula bar, press Enter.
Why A: Calculated tables are created via DAX expressions and can be used like regular tables, but they are computed at refresh time.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.