IF function for conditions in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Evaluate IF function with nested conditions

Given the DAX measure below, what is the output when the SalesAmount is 1500?

Result = IF(SalesAmount > 1000, "High", IF(SalesAmount > 500, "Medium", "Low"))

Power BI

Result = IF(SalesAmount > 1000, "High", IF(SalesAmount > 500, "Medium", "Low"))

A "High"

B "Medium"

C "Low"

D Blank

💡 Hint

Check the first condition and see if it is true for 1500.

Since 1500 is greater than 1000, the first IF condition is true, so the output is "High".

❓ visualization

intermediate

Choose the correct visualization for IF condition results

You created a measure using IF to categorize sales as "High", "Medium", or "Low". Which visualization best shows the count of sales in each category?

A Scatter plot of sales amount vs. date

B Line chart showing sales over time

C Table with raw sales data

D Pie chart showing percentage of each category

💡 Hint

Think about showing parts of a whole for categories.

A pie chart clearly shows the proportion of each sales category, making it easy to compare counts visually.

🧠 Conceptual

advanced

Understanding IF function short-circuit behavior

In Power BI DAX, when using nested IF functions, which statement is true about evaluation?

A All IF conditions are evaluated regardless of earlier results

B Only the first TRUE condition's result is returned, later conditions are not evaluated

C IF functions always return numeric values

D Nested IFs cannot be used inside measures

💡 Hint

Think about efficiency and how IF works in programming.

DAX IF functions stop evaluating once a TRUE condition is found, returning that result immediately.

🔧 Formula Fix

advanced

Identify the error in this IF function

What error will this DAX measure produce?

CheckValue = IF(SalesAmount > 1000, "High", "Medium", "Low")

A SyntaxError: Too many arguments in IF function

B Returns "High" for SalesAmount > 1000, else "Medium"

C No error, returns correct result

D Returns "Low" for all SalesAmount values

💡 Hint

Check the number of arguments IF accepts.

The IF function accepts only 3 arguments: condition, value if true, value if false. This has 4 arguments, causing a syntax error.

🎯 Scenario

expert

Create a measure to classify sales with multiple conditions

You want to create a DAX measure that classifies sales as:
- "Excellent" if SalesAmount > 2000
- "Good" if SalesAmount > 1000 and <= 2000
- "Average" if SalesAmount > 500 and <= 1000
- "Poor" if SalesAmount <= 500

Which of the following DAX expressions correctly implements this?

A SalesCategory = IF(SalesAmount > 2000, "Excellent", IF(SalesAmount > 1000 && SalesAmount <= 2000, "Good", IF(SalesAmount > 500 && SalesAmount <= 1000, "Average", "Poor")))

B SalesCategory = IF(SalesAmount >= 2000, "Excellent", IF(SalesAmount > 1000, "Good", IF(SalesAmount > 500, "Average", "Poor")))

C SalesCategory = IF(SalesAmount > 2000, "Excellent", IF(SalesAmount > 1000, "Good", IF(SalesAmount > 500, "Average", "Poor")))

D SalesCategory = IF(SalesAmount > 2000, "Excellent", IF(SalesAmount >= 1000, "Good", IF(SalesAmount >= 500, "Average", "Poor")))

💡 Hint

Remember that nested IFs check conditions in order, so use > and rely on order to cover ranges.

Option C correctly uses nested IFs with > comparisons and order to cover all ranges without overlap or gaps.