Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 17

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this question, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
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?

Answer options

Correct answer: B

Explanation

The correct answer is B because using grouping sets in DAX Studio does not inherently reduce the number of measures in Dataset1; it simply organizes data differently. The goal of reducing the number of measures while preserving functionality requires a different approach, such as creating a single measure that encapsulates the logic for all 50 measures.