Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SWITCH evaluation

As of now, experiments I realized with DAX on SSAS Level 1500, make me think that in the expression :

SWITCH(intValue,

value_1, expr1,

value_2, expr2,

...

value_N, exprN

)

the evaluation engine first evaluate all expr1, expr2, ..., exprN before selecting the correct expression to return. 

 

My questions are : does it really is the case ? Is there any workaround ?