Forum Discussion
KelvinMorel
Helper II
Helper IIInterest Rate -Weighted Average
Hi, I'm new to POWER BI, would like to calculate "Weighted Average" of salesmen but can't get around this, this sample of my data ACM RATE PERIODE WEIGHTED Salesman1 2,986 72 ...
The DAX-measure would look like this:
WAvg:=SUMX(Table1,Table1[RATE]*Table1[PERIODE])/SUM([PERIODE])
here is how it works:
https://powerpivotpro.com/2012/05/weighted-averages-another-use-of-sumx/
parry2k
Super User
Super Userdrop salesman and rate on your tabel visual, in drop down next to rate column, select average as aggregated method.