Forum Discussion

ZuzanaK's avatar
ZuzanaK
Frequent Visitor
3 years ago

weighted average

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 acros...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago
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.