Multiple measures variance in Sigle table

Hi naseem_1973 ,

Since you already have the measures in rows and the value gets split by Month, you should create a separate measure for Variance. You should also consider using Calculation Group to make this measure dynamic.

The Below is the link where you can read about Calculation Groups

https://community.fabric.microsoft.com/t5/Community-Blog/How-And-When-To-Use-Calculation-Groups-In-Power-BI/ba-p/1796197

Hi naseem_1973 ,

Is the Variance field the expected result?

I did some calculations and the variance of unique utilization is 3.8025%, the variance of service utilization is 9.8596%, which are different from yours.

3.8025=((7.59-5.64)²+(3.69-5.64)²)/2

If possible, please tell me how your expected result was calculated.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.