Forum Discussion

ana-pierola's avatar
ana-pierola
Frequent Visitor
3 years ago

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!

Best Practices
DAX
IF Functions
Switch()

1 Reply

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    I don't think that there would be any performance difference between the 2 but the first versions are much easier to read and maintain so I would use them