Easier way to do weighted average

[Ski900]

Is there any easier way to calculate weighted average compared to what I am doing right now? The current measure I am using returns the correct answer, but is probably the worst way to calculate it. Thanks for the help!

Avg User per Family =
var one = CALCULATE(SUM(Table[Count]), Table[UserCount] = 1)
var two = CALCULATE(SUM(Table[Count]), Table[UserCount] = 2)
var three = CALCULATE(SUM(Table[Count]), Table[UserCount] = 3)
var four = CALCULATE(SUM(Table[Count]), Table[UserCount] = 4)
var five = CALCULATE(SUM(Table[Count]), Table[UserCount] = 5)
var six = CALCULATE(SUM(Table[Count]), Table[UserCount] = 6)
var seven = CALCULATE(SUM(Table[Count]), Table[UserCount] = 7)
var eight = CALCULATE(SUM(Table[Count]), Table[UserCount] = 😎
var nine = CALCULATE(SUM(Table[Count]), Table[UserCount] = 9)
var ten = CALCULATE(SUM(Table[Count]), Table[UserCount] = 10)
var eleven = CALCULATE(SUM(Table[Count]), Table[UserCount] = 11)
var twelve = CALCULATE(SUM(Table[Count]), Table[UserCount] = 12)
var thirteen = CALCULATE(SUM(Table[Count]), Table[UserCount] = 13)
var fourteen = CALCULATE(SUM(Table[Count]), Table[UserCount] = 14)
var fifteen = CALCULATE(SUM(Table[Count]), Table[UserCount] = 15)
var sixteen = CALCULATE(SUM(Table[Count]), Table[UserCount] = 16)
var seventeen = CALCULATE(SUM(Table[Count]), Table[UserCount] = 17)
var eighteen = CALCULATE(SUM(Table[Count]), Table[UserCount] = 18)
var nineteen = CALCULATE(SUM(Table[Count]), Table[UserCount] = 19)
var total = SUM(Table[Count])

return
DIVIDE(
    one+2*two+3*three+4*four+5*five+6*six+7*seven+8*eight+9*nine+10*ten+11*eleven+12*twelve+13*thirteen+14*fourteen+15*fifteen+16*sixteen+17*seventeen+18*eighteen+19*nineteen,
    total
    )

Sample Data

Count	UserCount
78531859	0
815580	1
94599	2
16121	3
3859	4
1730	5
450	6
206	7
151	8
83	9
47	10
32	11
28	12
18	13
12	14
10	15
8	16
14	17
14	18
31	19

[alexei7]

Hi @Ski900,

Yeah, I'm pretty sure there's an easier way of doing it..

Would you be able to post a small sample of your data expected result? That'd make it easier to help

Thanks

Alex

[Ski900]

Data added!

[alexei7 · Accepted solution]

Thanks!

Try this:

Avg User per Family = DIVIDE(SUMX('Table','Table'[Count]*'Table'[UserCount]),sum('Table'[Count])) 

Hope that helps,

Alex

[Ski900]

Works perfectly. Thanks for the help 🙂