DAX Nesting Multiple IF statements

Question

I have 3 IF statements, each in a separate column...

Column 1 = IF(RELATED(dim_verification_measure5[measure_check_type])="min",IF([measure_value]<RELATED(dim_verification_measure5[measure_target_value_min]),20,10))
Column 2 = IF(RELATED(dim_verification_measure5[measure_check_type])="max",IF([measure_value]>RELATED(dim_verification_measure5[measure_target_value_min]),20,10))
Column 3 = IF(RELATED(dim_verification_measure5[measure_check_type])="between",IF([measure_value]>RELATED(dim_verification_measure5[measure_target_value_min]),IF([measure_value]<RELATED(dim_verification_measure5[measure_target_value_max]),20,10)))

The resulting value in each column is correct.

However, I would like the see all of the values in the same column. Is it possible to nest all of these IF statements?

davidebacci · Accepted Answer · 2022-12-05 17:36:11Z

2

Yes, but instead of nesting if statements which are difficult to read, we use the following:

SWITCH(TRUE(), 
value, result,
value, result,
else)

Alternatively, use COALESCE() on your existing 3 statements.

answered Dec 5, 2022 at 17:36

davidebacci

31.4k4 gold badges20 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ozan Sen Over a year ago

Please replace else with result!

davidebacci Over a year ago

What do you mean? That is exactly how it is described in the documentation: learn.microsoft.com/en-us/dax/switch-function-dax

davidebacci Over a year ago

SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>])

stuart Over a year ago

@DavidBacci - I used the COALESCE() method. Much neater than a lengthy nested statement. Thank you.

Collectives™ on Stack Overflow

DAX Nesting Multiple IF statements

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related