Forum Discussion
WSeirafi
Helper I
Helper IIF statement performance
Hello, I'm witnessing a performance issue for a quite simple measure used in a big table. If I use this measure, the result is instant Measure = VAR CurrentVal = SELECTEDVALUE ( Table[Column...
shafiz_p
Super User
Super UserHi WSeirafi With "if" statements, you need to go through each item one by one. When you have a huge table , using "if" statements can be slow. It’s like checking each item individually. The default query timeout is 225 seconds. Please check its performance. Try with switch function, because it faster than "if".
WSeirafiI answered below, unluckily it was not effective