Search code examples
powerbidaxdata-analysispowerbi-desktopmeasure

DAX Nesting Multiple IF statements

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.

enter image description here

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

Solution

  • 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.