Exam PL-300 topic 2 question 90 discussion

Actual exam question from Microsoft's PL-300

Question #: 90
Topic #: 2

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

Suggested Answer:

by Endeetheanalyst at Sept. 5, 2024, 1:21 p.m.

Comments

Submit Cancel

P_BKTX

Highly Voted 10 months, 3 weeks ago

IF is correct answer https://learn.microsoft.com/en-us/dax/if-function-dax check last example

upvoted 9 times

1CY1

10 months, 2 weeks 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 6 months ago

I would also answer IF

upvoted 1 times

...

SylUK

6 months, 1 week 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

8 months, 2 weeks 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

10 months, 2 weeks 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

10 months, 3 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

...