DP-500 Question #132: Real Exam Question with Answer & Explanation

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.

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.

Full DP-500 Practice Browse All DP-500 Questions