Measure Performance

[mikebi]

Hello,

I have been working on a performance issue and I have found this performs slow:

VAR ReturnValue = IF( ReturnBlank = 1 ,Blank(),
Return DIVIDE (
Expense,
Sales,
"NA"
)
)

And this performs fast

Return DIVIDE (
Expense,
Sales,
"NA"
)

Why would introducing an If Statement in a Return cause make the measure 4 times slower?  

What can I do to troubleshoot?

Thank You,

Michael

[Ritaf1983 · Accepted solution]

Hi @mikebi 
Try to use calculate and filter instead of if.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly