Forum Discussion

WSeirafi's avatar
WSeirafi
Icon for Helper I rankHelper I
2 years ago

IF 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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

WSeirafi ISBLANK is notorious for bad performance. Try this:

 

Measure =
IF (
    SELECTEDVALUE ( Table[Column] ) = BLANK(),
    1,
    0
)

 

or

 

Measure =
IF (
    SELECTEDVALUE ( Table[Column] ) <> BLANK(),
    0,
    1
)

or

Measure =
SWITCH( SELECTEDVALUE ( Table[Column] ),
    BLANK(), 1,
    0
)

 

WSeirafi's avatar
WSeirafi
Icon for Helper I rankHelper I
2 years ago

I tried with both suggestions you gave

Measure =
VAR CurrentVal = SELECTEDVALUE ( Table[Column] )
RETURN
    SWITCH(CurrentVal,
        BLANK(),1,
        0
    )
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
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    WSeirafi 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?

    • WSeirafi's avatar
      WSeirafi
      Icon for Helper I rankHelper I
      2 years ago

      Might be a solution

    • WSeirafi's avatar
      WSeirafi
      Icon for Helper I rankHelper I
      1 year ago

      Hello,

       

      I ended up merging all my data into one big table for this purpose, but my issue now is that when I use a Switch / if measure in my table, the slicer do not have any effect on it.

      I guess it's the fact that the IF measure returns a value for every rown but how can I prevent this from happening ?

      Thanks for your help