Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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!
Solved! Go to 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.
@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.
@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
User | Count |
---|---|
91 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |