Forum Discussion

dvillegas's avatar
dvillegas
Frequent Visitor
6 years ago
Solved

Calculating Average with Prorated Values

I am trying to calculate the average score per month for a group of people. The calc should be sum of score divided by sum of months. The  problem I am having is when a person has more than one score...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi dvillegas, 

    You could use below measure to get 5.5

    Measure 3 = SUMX(ALL(TEST),TEST[Score]*TEST[Monthly Portion])/SUMX(ALL(TEST),TEST[Monthly Portion])

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Community Support
6 years ago

Hi dvillegas, 

You could use below measure to get 5.5

Measure 3 = SUMX(ALL(TEST),TEST[Score]*TEST[Monthly Portion])/SUMX(ALL(TEST),TEST[Monthly Portion])

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.