Calculated Columns and Measures are two key ways to create calculations in Power BI using DAX. While calculated columns store values for each row in the table, measures calculate results dynamically based on the filter context in reports. Understanding their differences is essential for optimizing performance, reducing data model size, and ensuring accurate analysis.
Time limit: 0
Quiz Summary
0 of 15 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
What is a primary characteristic of a calculated column in Power BI?
Correct
Incorrect
Question 2 of 15
2. Question
Which of the following is true for measures?
Correct
Incorrect
Question 3 of 15
3. Question
When would you prefer a measure over a calculated column?
Correct
Incorrect
Question 4 of 15
4. Question
Which statement is correct about calculated columns?
Correct
Incorrect
Question 5 of 15
5. Question
Which DAX function type is common in both calculated columns and measures?
Correct
Incorrect
Question 6 of 15
6. Question
Which of the following increases the size of your Power BI file?
Correct
Incorrect
Question 7 of 15
7. Question
Which one is evaluated in row context by default?
Correct
Incorrect
Question 8 of 15
8. Question
Which one depends on filter context for calculation?
Correct
Incorrect
Question 9 of 15
9. Question
Can calculated columns be created using DirectQuery mode?
Correct
Incorrect
Question 10 of 15
10. Question
Which option is best for time intelligence calculations like YTD or MTD?
Correct
Incorrect
Question 11 of 15
11. Question
Which is true about storage impact?
Correct
Incorrect
Question 12 of 15
12. Question
If you need a new field for joining tables, which should you use?
Correct
Incorrect
Question 13 of 15
13. Question
Which one can be aggregated directly in a visual without being stored in the table?
Correct
Incorrect
Question 14 of 15
14. Question
Which type recalculates only during data refresh?
Correct
Incorrect
Question 15 of 15
15. Question
Which of these is NOT an advantage of measures over calculated columns?
Correct
Incorrect
Summary
These Calculated Columns vs Measures MCQs explain when to use each, highlighting differences in storage, calculation context, performance impact, and usability in relationships and slicers. Choosing the right option ensures efficient Power BI models and accurate reporting.
At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.
