Microsoft
DP-500 · Question #132
QUESTION 177 Hotspot Question You have a Power BI model that contains three tables named Sales, Marketing, and Delivery. The Sales table relates to the Marketing and Delivery tables. The Marketing…
The DAX expression should be: CALCULATE( SUM(Sales[SalesAmount]), TREATAS( VALUES({Marketing[Region]}), Delivery[Region]))
Implement and manage data models
Question
QUESTION 177 Hotspot Question You have a Power BI model that contains three tables named Sales, Marketing, and Delivery. The Sales table relates to the Marketing and Delivery tables. The Marketing and Delivery tables do NOT relate to each other. You need to create a measure to meet the following requirements: - Sum the values in a column named Sales[SalesAmount]. - Ensure that the tables and relationships remain unchanged. - If a user applies a filter to a column named Marketing[Region], apply the same filter to a column named Delivery[Region]. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Exhibit
Explanation
The DAX expression should be: CALCULATE( SUM(Sales[SalesAmount]), TREATAS( VALUES({Marketing[Region]}), Delivery[Region]))
Topics
#DAX#Filter Context#Disconnected Tables#Cross-Table Filtering
Community Discussion
No community discussion yet for this question.