CODEWITHSUNDEEP
powerbidaxdata-analysispowerbi-desktopmeasure
stuart
stuart

Reputation: 29

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?

Upvotes: 1

Views: 845

Answers (1)

davidebacci
davidebacci

Reputation: 30324

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.

Upvotes: 2

Related Questions