Exam DP-500 topic 1 question 177 discussion

Actual exam question from Microsoft's DP-500

Question #: 177
Topic #: 1

HOTSPOT
-

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.

Show Suggested Answer

Suggested Answer:

by Cata23 at Nov. 20, 2023, 1:21 p.m.

Comments

Submit Cancel

Cata23

Highly Voted 1 year, 7 months ago

The correct answer is: TREATAS and VALUES

upvoted 6 times

...

Momoanwar

Most Recent 1 year, 5 months ago

treatas and Values. Chatgpt : To create a DAX measure according to the requirements, you should use the following expression: CALCULATE( SUM(Sales[SalesAmount]), TREATAS(VALUES(Marketing[Region]), Delivery[Region]) ) Here's what each function does in this context: - `CALCULATE` changes the context in which the data is aggregated and is used here to sum the `SalesAmount` while applying a filter context. - `SUM(Sales[SalesAmount])` adds up all the values in the `SalesAmount` column from the Sales table. - `TREATAS` takes the values from the `Marketing[Region]` column and treats them as if they were values in the `Delivery[Region]` column, effectively transferring the filter context from the Marketing table to the Delivery table. This is necessary since there is no direct relationship between Sales and Delivery, but both are related to Marketing.

upvoted 1 times

...

MaryemSB

1 year, 6 months ago

Treatas and Values https://learn.microsoft.com/en-us/dax/treatas-function

upvoted 2 times

...