Exam DP-500 topic 1 question 98 discussion

Actual exam question from Microsoft's DP-500

Question #: 98
Topic #: 1

DRAG DROP -
You have a Power BI dataset that contains the following measures:

Budget -

Actuals -

Forecast -
You create a report that contains 10 visuals.
You need to provide users with the ability to use a slicer to switch between the measures in two visuals only.
You create a measure named CG Measure Switch.
How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriate values to the targets. Each value 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.

Show Suggested Answer

Suggested Answer:

by Ramiel at Dec. 20, 2022, 3:55 p.m.

Comments

Submit Cancel

cookiemonster42

Highly Voted 2 years, 5 months ago

SELECTEDMEASURENAME and SELECTEDMEASURE As Maazi said, ISSELECTEDMEASURE() returns boolean and SELECTEDVALUE is irrelevant.

upvoted 10 times

...

Ramiel

Highly Voted 2 years, 6 months ago

The answer should be: SELECTEDMEASURENAME() and SELECTEDVALUE() This question already appeared, and this was the provided (correct, IMO) answer.

upvoted 7 times

Maazi

2 years, 6 months ago

I agree with you. Moreover, the ISSELECTEDMEASURE() function returns a boolean

upvoted 4 times

Maazi

2 years, 6 months ago

Should be SELECTEDMEASURENAME and SELECTEDMEASURE

upvoted 9 times

...

mocashe

2 years ago

Yes, you are right. This same question already exists in #75. So, the answer should be SELECTEDMEASURENAME()and SELECTEDVALUE().

upvoted 3 times

...

Eltooth

Most Recent 2 years ago

SELECTEDMEASURENAME SELECTEDMEASURE As per Q#75

upvoted 2 times

...

solref

2 years, 3 months ago

SELECTEDMEASURENAME and SELECTEDMEASURE * ISSELECTEDMEASURE requires a list of measure names and in this case it was not provided, and the calculation is evaluating an equal (=) for specific measure name.

upvoted 5 times

...

Saffar

2 years, 5 months ago

answer is correct, SELECTEDVALUE need a column name as input, you can't use SELECTEDVALUE(), check below https://learn.microsoft.com/en-us/dax/selectedvalue-function

upvoted 4 times

...