Learn how to use DAX in Power BI to create a calculated measure that scores opportunities as low, medium, or high based on a qualification value between 0 and 1. Step-by-step solution with a detailed explanation.
Table of Contents
Question
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.
Sales Qualification =
IF (
‘Opportunity’ [Qualification] < 0.5,
“Low”,
__________ (
‘Opportunity’ [Qualification] > 0.7,
__________
__________
)
)
A. ELSE
B. IF
C. IF.EAGER
D. OR
A. HIGH
B. LOW
C. MEDIUM
A. HIGH
B. LOW
C. MEDIUM
Answer
C. IF.EAGER
A. HIGH
C. MEDIUM
Explanation
To create a measure in Power BI that categorizes opportunities as low, medium, or high based on the Qualification column value, you can use the following DAX formula:
Sales Qualification =
IF (
‘Opportunity'[Qualification] < 0.5,
“Low”,
IF (
‘Opportunity'[Qualification] > 0.7,
“High”,
“Medium”
)
)
Here’s how the formula works:
1. The outermost IF function checks if the Qualification value is less than 0.5.
– If true, it returns “Low”.
– If false, it moves to the next argument.
2. The second argument of the outermost IF function is another IF function. This one checks if the Qualification value is greater than 0.7.
– If true, it returns “High”.
– If false, it returns “Medium”.
So in summary:
– Opportunities with Qualification < 0.5 are categorized as “Low”.
– Opportunities with Qualification > 0.7 are categorized as “High”.
– Opportunities with 0.5 <= Qualification <= 0.7 are categorized as “Medium”.
The correct options to fill in the blanks are:
– First blank: IF
– Second blank: “High”
– Third blank: “Medium”
This nested IF approach allows you to define the thresholds for low, medium and high, and categorize the opportunities accordingly in your Power BI semantic model.
Microsoft PL-300 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Microsoft PL-300 exam and earn Microsoft PL-300 certification.