IF statement performance

Question

Hello,&nbsp;I'm witnessing a performance issue for a quite simple measure used in a big table.If I use this measure, the result is instantMeasure = VAR CurrentVal = SELECTEDVALUE ( Table[Column] )RETURN&nbsp; &nbsp; CurrentVal&nbsp;However if I use this measureMeasure = IF (&nbsp; &nbsp; ISBLANK (&nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE ( Table[Column] )&nbsp; &nbsp; ),&nbsp; &nbsp; 1,&nbsp; &nbsp; 0)&nbsp;The visual goes in error after several minutes loading. What is that due to and is there a way around this ?Regards

greg_deckler · Answer

WSeirafi&nbsp;ISBLANK is notorious for bad performance. Try this:
&nbsp;
Measure =
IF (
    SELECTEDVALUE ( Table[Column] ) = BLANK(),
    1,
    0
)
&nbsp;
or
&nbsp;
Measure =
IF (
    SELECTEDVALUE ( Table[Column] ) &lt;&gt; BLANK(),
    0,
    1
)
or
Measure =
SWITCH( SELECTEDVALUE ( Table[Column] ),
    BLANK(), 1,
    0
)
&nbsp;

shafiz_p · Answer

Hi WSeirafi&nbsp; 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".

wseirafi · Answer

I tried with both suggestions you gaveMeasure = VAR CurrentVal = SELECTEDVALUE ( Table[Column] )RETURN&nbsp; &nbsp; SWITCH(CurrentVal,&nbsp; &nbsp; &nbsp; &nbsp; BLANK(),1,&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; )Didn't change anything. There is no other way to do this ?I would have added a calculated column, but this is supposed to be reacting to a slicer

wseirafi · Answer

I answered below, unluckily it was not effective

greg_deckler · Answer

WSeirafi&nbsp;It's hard to say with the information provided. Would need additional context of the problem you are actually trying to solve. Is this something that could be done using the Filter pane?

Forum Discussion

IF statement performance

7 Replies

Related content

DAX Performance

DAX performance optimization

OR Statement ?

Fabric Pipeline Performance

SQL Statement opcion error