Multiple measures variance in Sigle table

[naseem_1973]

Dear All,

I want to create a dynamic table in Power BI like below.  Is there any shortcut where I can take variance in multiple measures?

Note: The example table is in Excel format.

I have already all the measures like unique utilization, service utilization, etc.

[Anonymous]

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.           

[naseem_1973]

Dear Stephen , 

Check my calculation method in excel

[naseem_1973]

Dear Stephen , 

I did in excel . Check below method.

[Thejeswar]

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