weighted average

[ZuzanaK]

Hello,

I am struggling to create weighted average as this case is sort of unusual. Essentially, most of the campaigns have multiple strategies where I want to create uplift weighted average across strategies for each campaign respectively. Once I have that I would like to create uplift weighted average across all campaigns per each month. 

Any suggestions?

Thanks,

Z

Campaign Id	Strategy Id	Month	Budget	Booked Uplift
63f5ebc348636621c86a4666	63f5ec3ef39e1f27e771b634	March	50000	23
63f5ebc348636621c86a4666	63f5ed4e48636621c86a46d	March	20000	0
63f5ebc348636621c86a4666	63f77076f39e1f27e771b6d	March	9000	2
63f5ebc348636621c86a4666	63ff45ffd9d5047da9f9ddde	March	3000	11
638646475ff14c20d5065344	6389daa20720a332eb340se	March	10000	4
638646475ff14c20d5065344	6389e202ad090878732f8cjg	March	9000	68
638646475ff14c20d5065344	6389e25bad090878732f8cje	March	64000	240
638646475ff14c20d5065344	6389f187ad090878732f8cjd	March	1000	48

[lbendlin]

Weighted uplift = 
var a = SUMMARIZE(Campaigns,Campaigns[Campaign Id],"bd",sum(Campaigns[Budget]),"ul",sumx(Campaigns,Campaigns[Budget]*Campaigns[Booked Uplift]))
return sumx(a,[ul])/sumx(a,[bd])

(you should use DIVIDE() to safeguard against division by zero)

see attached.