Forum Discussion
Slow Switch Statement
Hey, I'm trying to create one measure, that will return other measures based on another unrelated 'Measure' table, that I will use as a column in a Matrix. The below DAX expression does the trick...
v-xicai
Community Support
Community SupportHi Anonymous ,
Az38' suggestion is great. In addition, you may improve the performance of measures used in your SWITCH formula, such as [Actual], [Forecast], [Budget],,,etc.
For example:
Use SELECTEDVALUE() instead of VALUES()
Use ISBLANK() instead of =Blank() check
Do not use scalar variables in SUMMARIZE()
Use variables instead of repeating measures inside the IF branch
You may refer to the tips:
Improve Power BI Performance by Optimizing DAX
A comprehensive guide to Power BI performance tuning
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.