Nested ifs vs. pick match

[chriys1337]

Hello,

I am having performance issues with heavy nested ifs. My question is, how to optimize the logic? Is a pick match solution, a guarantee for a better performance?

Whats your thoughts on this?

Thx,

chriys

[Anil_Babu_Samineni · Accepted solution]

My contribution here is, I've converted 120 nested..if conditions to Pick..Match condition which is really increasing the performance. like

• Filter selection improving immediate
• We can use them even Calc. Dimension using Pick..Match function where as If..else condition kills performance
• Safer zone, Create in script as filed which will run proper even If.else or Pick.Match

[chriys1337]

Thank you for sharing your experience, Anil!

[KatarinaGrumy]

Thank you!!