How to Use IF in DAX in Power BI: Simple Guide

In Power BI, use the IF function in DAX to test a condition and return one value if true and another if false. The syntax is IF(condition, result_if_true, result_if_false). It helps create dynamic calculations based on your data.

Syntax

The IF function in DAX checks a condition and returns a value based on whether the condition is true or false.

• condition: A logical test that returns TRUE or FALSE.
• result_if_true: The value returned if the condition is TRUE.
• result_if_false: The value returned if the condition is FALSE.

DAX

IF(<condition>, <result_if_true>, <result_if_false>)

Example

This example creates a new measure that checks if sales are greater than 1000. If yes, it returns "High", otherwise "Low".

DAX

Sales Category = IF(SUM(Sales[Amount]) > 1000, "High", "Low")

Output

If total sales amount is 1200, output is "High"; if 800, output is "Low".

Common Pitfalls

Common mistakes when using IF in DAX include:

• Forgetting to provide the result_if_false argument, which defaults to BLANK() and may cause unexpected blanks.
• Using complex conditions without parentheses, leading to wrong logic.
• Trying to use IF for multiple conditions instead of SWITCH or nested IF properly.

DAX

Wrong: IF(SUM(Sales[Amount]) > 1000, "High")
Right: IF(SUM(Sales[Amount]) > 1000, "High", "Low")

Quick Reference

Part	Description	Example
condition	Logical test to check	SUM(Sales[Amount]) > 1000
result_if_true	Value if condition is true	"High"
result_if_false	Value if condition is false	"Low"

Key Takeaways

Use IF(condition, true_result, false_result) to create simple conditional logic in DAX.

Always provide the false_result to avoid unexpected blank results.

For multiple conditions, consider nested IF or SWITCH for clarity.

Use parentheses to group complex conditions correctly.

Test your IF expressions with sample data to ensure correct logic.