nerdexam
Microsoft

DP-500 · Question #28

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. Writing a query with grouping sets in DAX Studio is for ad-hoc analytical aggregations and does not modify or reduce the number of measures defined in a Power BI dataset.

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 DAX Studio, you write a query that uses grouping sets. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(43 responses)
  • A
    28% (12)
  • B
    72% (31)

Why each option

Writing a query with grouping sets in DAX Studio is for ad-hoc analytical aggregations and does not modify or reduce the number of measures defined in a Power BI dataset.

AYes

DAX Studio queries, including those using grouping sets, are for data analysis and do not modify the data model to reduce the count of defined measures.

BNoCorrect

DAX Studio is a tool for analyzing, debugging, and tuning DAX queries. Writing a query using grouping sets allows for complex aggregations and analysis at query time, but it does not alter the underlying data model's structure, nor does it reduce the number of measures permanently stored within the Power BI dataset.

Concept tested: DAX Studio grouping sets purpose

Source: https://dax.studio/

Topics

#DAX Queries#Measures#Data Model Optimization#DAX Studio

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-500 Practice