IF/SWITCH measure performance
Hi, I have a general question about the best way to write if/switch measures. Is any of the following examples (1 and 2) more efficient than the other? 1) if_measure = IF(condition_measure = value1, [measure1], [measure2]) switch_measure = SWITCH(condition_measure, value1, [measure1], value2, [measure2], [measure3]) 2) if_measure = IF(condition_measure = value1, DAX code for measure 1, DAX code for measure 2) switch_measure = SWITCH(condition_measure, value1, DAX code for measure 1, value2, DAX code for measure 2, DAX code for measure 3) Thanks!