Variance and Variance % between 2 measures

[jessset]

Hi there,

I have 2 measures which by itself does a lot of calculations. However, I need the Variance between those 2 measures, and the Variance % of those 2 measures. How I've done it is as below:

• Variance = [Measure 1] - [Measure 2]
• Variance % = [Measure 1]/[Measure 2] -1

These 4 measures are then on a matrix table.

I understand doing it this way means Measure 1 and Measure 2 will each be calculated 3 times, which is really slowing down the performance. Is there any ideas to make this quicker?

Thanks!

[V-pazhen-msft · Accepted solution]

@jessset 

Or you can transform Measure 1 and Measure 2  into calculate columns, so it is pre-calculated and saved in the pbix, this would increase the pbix size but increase the performance.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  

[amitchandak]

@jessset , I think you have done it the right way. The only change you can do is

Variance % = divide([Measure 1]-[Measure 2],[Measure 2] )

This can help to improve performance

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-sho...