DP-500 · Question #27
You have a Power BI dataset named Dataset1. In Dataset1, you currently have 50 measures that use the same time intelligence logic. You need to reduce the number of measures, while maintaining the…
The correct answer is B. No. While calculation groups consolidate measure logic, simply creating one does not automatically reduce the count of existing measures; further refactoring and deletion are required.
Question
Options
- AYes
- BNo
How the community answered
(47 responses)- A23% (11)
- B77% (36)
Why each option
While calculation groups consolidate measure logic, simply creating one does not automatically reduce the count of existing measures; further refactoring and deletion are required.
Creating a calculation group introduces a new object and enables consolidation, but it does not by itself reduce the count of existing measures without subsequent refactoring and removal of the old measures.
Calculation groups are designed to consolidate repetitive DAX logic, potentially reducing the number of explicit measures needed for similar calculations. However, simply 'creating a calculation group' in Tabular Editor does not automatically reduce the count of 50 existing measures; those measures would need to be replaced by a single base measure and calculation items, and then deleted from the model, to achieve a reduction in the measure count.
Concept tested: Calculation group implementation to reduce measures
Source: https://learn.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions
Topics
Community Discussion
No community discussion yet for this question.