Variance Calulation

[Anonymous]

Hi Team,

I have below table in backend

ProjId	Emp	Monthly Actual Hours	Monthly Budget Hours	Variance ( act - Bud )	var %
1	Sen Mnager	100	120	-20	-16 %
1	Developer	150	80	70	87.5 %

In table visual   I wanted , 

ProjId	Monthly Act Hours	Budget Hours	var	var %
1	250	200	50	50/200  -> 25 %

var % calculation is not coming right in table visual. Could you please help me with this ?

Thanks,

Shubham

[amitchandak]

@Anonymous , Create measure like

Monthly Actual = sum(Table[Monthly Actual Hours])
Monthly Budget = sum(Table[Monthly Budget Hours])

var = [Monthly Actual] -[Monthly Budget]
var %= divide([Monthly Actual] -[Monthly Budget],[Monthly Budget])

[lkalawski · Accepted solution]

Hi @Anonymous 

Instead of using columns and summarize values, please create 3 measures:

SumOfBudgetHours = Sum('Table'[Monthly Budget Hours ])
SumOfVariance = Sum('Table'[Variance ( act - Bud ) ])
Var %_M = DIVIDE([SumOfVariance], [SumOfBudgetHours],0)

And please add the last one instead of the var %.

_______________
If I helped, please accept the solution and give kudos! 😀