Exam DP-500 All QuestionsBrowse all questions from this exam
Go to Exam
Question 144

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.

    Correct Answer:

Discussion
Qordata

For dropbox 2 it should be ALLSELECTED b/c question states: The measure must respect the report-level filter when calculating the total. https://learn.microsoft.com/en-us/dax/allselected-function-dax

Sreelesh

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.

MaryemSB

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.