Forum Discussion

st-mb's avatar
st-mb
Frequent Visitor
7 years ago
Solved

Weighted Average from Measures

Hello,   I'm trying to calculate the weighted average of a contribution score with some existing measures, but I just can't seem to get this one right.   There's three work orders tables (site a ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi st-mb

     

    You may refer to below measure. If it is not your case, please share some data sample.

    Measure =
    SUMX (
     SUMMARIZE ( Table, Table[Name] ),
     [Total Work Completed] * [Contribution Percentage]
    )
     / [Total Work Completed]

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi st-mb

 

You may refer to below measure. If it is not your case, please share some data sample.

Measure =
SUMX (
 SUMMARIZE ( Table, Table[Name] ),
 [Total Work Completed] * [Contribution Percentage]
)
 / [Total Work Completed]

Regards,

Cherie