Forum Discussion

Gonqq's avatar
Gonqq
Icon for Helper I rankHelper I
5 years ago

Optimizing a DAX Formula

Hi everyone. I'm having trouble with a small dax formula: it consumes a lot of memory and i can't add anymore rows to a mtarix because of it. The formula is the following: It was one of my fir...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Gonqq One way would be to have your GE row be this:

VAR GE = DIVIDE(R; P; "N/Orc")

  • Gonqq's avatar
    Gonqq
    Icon for Helper I rankHelper I
    5 years ago

    Hi Greg_Deckler , thank you. I tried it out and it still pulls a lot of memory. I'm almost certain that it's the switch condition that's causing the problem but i really must have that condition.

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Gonqq Try: VAR C = IF(gc + R + P = 62, "n.a";GE)

      Arithmatic is faster than comparison operators and no need for a SWITCH if it is just a single condition.