exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 90 discussion

Actual exam question from Microsoft's PL-300
Question #: 90
Topic #: 2
[All PL-300 Questions]

HOTSPOT -

You have a Power BI semantic model that contains a table named Opportunity.

The Opportunity table contains a column named Qualification. The Qualification column contains values between 0 and 1.

You need to build a new measure to score the opportunities on a scale of low. medium, and high.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
P_BKTX
Highly Voted 7 months, 2 weeks ago
IF is correct answer https://learn.microsoft.com/en-us/dax/if-function-dax check last example
upvoted 9 times
1CY1
7 months, 1 week ago
I'm going with just 'IF'. IF.Eager seems to only be required for variant data type comparison... The IF.EAGER function can return a variant data type if value_if_true and value_if_false are of different data types, but the function attempts to return a single data type if both value_if_true and value_if_false are of numeric data types. In the latter case, the IF.EAGER function will implicitly convert data types to accommodate both values.
upvoted 2 times
...
...
drigotto8
Most Recent 2 months, 3 weeks ago
I would also answer IF
upvoted 1 times
...
SylUK
2 months, 4 weeks ago
The IF.EAGER,HIGH, MEDIUM are the correct answer: In Power BI's DAX language, the primary difference between the "IF" and "IF.EAGER" functions lies in their evaluation strategy: "IF" only evaluates the expression corresponding to the true or false condition based on the logical test, while "IF.EAGER" always evaluates both expressions regardless of the condition, which can sometimes lead to performance improvements in specific scenarios where both branches need to be calculated regardless of the outcome. See this link:https://learn.microsoft.com/en-us/dax/if-eager-function-dax
upvoted 2 times
...
jaume
5 months ago
I would vote for the IF not IF.EAGER as I cannot see the point to use second one. Then HIGH & MEDIUM
upvoted 1 times
...
miloszmiloszz
7 months ago
I will use IF instead of IF.EAGER due to values that are used in true/false arguments. If there would be more complex values (another formulas, references to columns etc.) I will prefer IF.EAGER. See https://learn.microsoft.com/en-us/dax/if-eager-function-dax -cdot above Examples part.
upvoted 3 times
...
Tex02
7 months, 2 weeks ago
interestingly this article - https://dax.guide/if-eager/ - indicates that if and if.eager do pretty much the same thing but if.eager optimises better. So I can't say the answer is incorrect but which one are they looking for can't say.
upvoted 1 times
...
b9e3c84
7 months, 3 weeks ago
The correct answer is IF, HIGH and MEDIUM
upvoted 4 times
...
nelrosell
7 months, 3 weeks ago
IF is also fine
upvoted 2 times
...
Endeetheanalyst
7 months, 3 weeks ago
Answer is correct. https://learn.microsoft.com/en-us/dax/if-eager-function-dax
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago