Answer-first summary for fast verification
Answer: Combine multiple financial calculations into a single measure using calculation groups, leveraging the CALCULATE function to dynamically apply filters based on the selected region.
Calculation groups in DAX are designed to improve query performance and maintainability by allowing multiple calculations to be combined into a single measure. This approach reduces the number of measures needed and leverages the CALCULATE function to dynamically apply filters, such as region, making it scalable and efficient. Option A does not utilize calculation groups, leading to potential performance issues. Option C, while functional, does not leverage the specific benefits of calculation groups for dynamic filtering. Option D would result in a bloated and inflexible model, contrary to best practices for semantic modeling.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are tasked with designing a semantic model for a manufacturing company that requires efficient query performance across various financial metrics. The company operates in multiple regions and needs to compare performance across these regions dynamically. To achieve this, you decide to implement calculation groups in your model. Considering the need for scalability, maintainability, and performance, which of the following approaches should you take to effectively use calculation groups in your model? (Choose one correct answer)
A
Develop individual measures for each financial metric and manually group them in the reporting tool, relying on the tool's capabilities to manage performance.
B
Combine multiple financial calculations into a single measure using calculation groups, leveraging the CALCULATE function to dynamically apply filters based on the selected region.
C
Implement a single measure that uses the SWITCH function to return different calculations based on the user's selection, without utilizing calculation groups.
D
Avoid using calculation groups and instead, pre-calculate all possible combinations of financial metrics and regions in the data model.