Exam DP-500 topic 1 question 147 discussion

Actual exam question from Microsoft's DP-500

Question #: 147
Topic #: 1

DRAG DROP
-

You have a Power BI data model that contains two tables named Products and Sales.

A one-to-many relationship exists between the tables.

You have a report that contains a report-level filter for Products.

You need to create a DAX measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.

How should you complete the measure? To answer, drag the appropriate DAX functions to the correct targets. Each function may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Qordata at Dec. 13, 2023, 10:47 a.m.

Comments

Submit Cancel

Sreelesh

11 months, 1 week ago

It's CALCULATE and ALLSELECTED. When ALLSELECTED is used, all the report level filters are preserved and that is what exactly the question is about.

upvoted 1 times

...

MaryemSB

1 year, 6 months ago

1. CALCULATE 2. ALLSELECTED second is not ALL because "ALLSELECTED only ignores the filters coming from inside the visual itself, whereas ALL ignores any filters coming from anywhere in this visual or other visual on the page" https://radacad.com/power-bi-dax-all-vs-allselected#:~:text=The%20ALLSELECTED%20is%20also%20a,other%20visual%20on%20the%20page.

upvoted 1 times

...