If statement for calculation heavy functions

[GAPER]

Hi all, 

I am trying to make a if statement like this

If (measure >1000, "n/m", measure)

However, in this case the i wonder if powerbi is doing the measure calculation 2 times which may significantly slower the run time.

Have been thinking to use Min(1000, Measure) but i would like to return the result "n/m" if the result is bigger than 1000

Thanks!

[jdbuchanan71 · Accepted solution]

You can avoid calcualting the mesure twice by assigning it to a variable.

YourMeaures =
VAR _Amount = [Measure] 
RETURN IF ( _Amount > 1000, "n/m", _Amount )