Forum Discussion

Anto123's avatar
Anto123
Frequent Visitor
7 years ago

Calculating weighted average

Need help I have both the data points in same column so not sure how to get the weighted average. In the below example, i need to find Weighted average for ASA(Seconds) based on Vol. Handled   ...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anto123,

 

Please refer to below formula to create a calculated column.

Weighed Average =
CALCULATE (
    SUM ( Table[Value] ),
    FILTER ( ALLEXCEPT ( Table, Table[Skill] ), Table[Matric] = "ASA(Seconds)" )
)
    / CALCULATE (
        SUM ( Table[Value] ),
        FILTER ( ALLEXCEPT ( Table, Table[Skill] ), Table[Matric] = "Vol. Handled" )
    )

If it does not meet your requirement, please illustrate how to calculate "Weighted average for ASA(Seconds) based on Vol. Handled". And show us your desired result with above sample table.

 

Best regards,

Yuliana Gu

  • Anto123's avatar
    Anto123
    Frequent Visitor
    7 years ago

    I have attached the calculation