nerdexam
Microsoft

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.

Implement and manage data models

Question

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 current functionality. Solution: From Tabular Editor, you create a calculation group. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(47 responses)
  • A
    23% (11)
  • B
    77% (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.

AYes

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.

BNoCorrect

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

#Calculation Groups#Measure Optimization#Time Intelligence#Tabular Editor

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice