Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi 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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the feedback. Unfortunately I've already optimised the source measures and don't think I can speed them up much more. The real issue is with the consolidation of the measures in the switch