Forum Discussion
selimovd
Most Valuable Professional
Most Valuable ProfessionalPerformance with many SWITCH or IFs slow. Is there a solution with good performance?
Hello everyone,
I have a kind of complex scenario and don't really know how I can solve that with appropriate performance.
I have a master measure that is, depending on a slicer, calculating ...
Calculation groups may not help, the best performance can be obtained by using SWITCH but you have to pay attention to the details. See this article+video: Understanding the optimization of SWITCH - SQLBI
marcorussoMost Valuable Professional
Most Valuable ProfessionalCalculation groups may not help, the best performance can be obtained by using SWITCH but you have to pay attention to the details. See this article+video: Understanding the optimization of SWITCH - SQLBI
selimovdMost Valuable Professional
Most Valuable ProfessionalThank you very much marcorusso , the approach mentioned in the article could solve the issue.
The visual with 20 measures that all of them use a SWITCH with 19 options went from 40 seconds to 1.8 seconds after optimization!