Forum Discussion
calculating weighted average
Hello all , I want to have a dax formula to calculat the weighted average for the next scenario. i have 10 participants , which 8 participants scored a 1 and 2 participants scored a 4. So...
If Scores is your table then
Measure = SUM(Scores[Score])/COUNTROWS(Scores)
should do it. Your formula is equivalent to just summing up the scores column and divide by number of rows, right?
erik_tarnvik
Solution Specialist
Solution SpecialistIf Scores is your table then
Measure = SUM(Scores[Score])/COUNTROWS(Scores)
should do it. Your formula is equivalent to just summing up the scores column and divide by number of rows, right?