Calculating weighted average

[Anto123]

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

Skill	Metric	Date	Value
Tier 1	Vol. Handled	09-01-2018	100
Tier 1	Vol. Handled	09-02-2018	130
Tier 1	Vol. Handled	09-03-2018	189
Tier 1	Vol. Handled	09-04-2018	90
Tier 1	Vol. Handled	09-05-2018	67
Tier 1	Vol. Handled	09-06-2018	78
Tier 1	Vol. Offered	09-01-2018	110
Tier 1	Vol. Offered	09-02-2018	140
Tier 1	Vol. Offered	09-03-2018	199
Tier 1	Vol. Offered	09-04-2018	100
Tier 1	Vol. Offered	09-05-2018	77
Tier 1	Vol. Offered	09-06-2018	88
Tier 1	ASA(Seconds)	09-01-2018	120
Tier 1	ASA(Seconds)	09-02-2018	140
Tier 1	ASA(Seconds)	09-03-2018	60
Tier 1	ASA(Seconds)	09-04-2018	89
Tier 1	ASA(Seconds)	09-05-2018	98
Tier 1	ASA(Seconds)	09-06-2018	12
Tier 2	Vol. Handled	09-01-2018	130
Tier 2	Vol. Handled	09-02-2018	123
Tier 2	Vol. Handled	09-03-2018	167
Tier 2	Vol. Handled	09-04-2018	89
Tier 2	Vol. Handled	09-05-2018	67
Tier 2	Vol. Handled	09-06-2018	78
Tier 1	Vol. Offered	09-01-2018	140
Tier 1	Vol. Offered	09-02-2018	133
Tier 1	Vol. Offered	09-03-2018	177
Tier 1	Vol. Offered	09-04-2018	99
Tier 1	Vol. Offered	09-05-2018	77
Tier 1	Vol. Offered	09-06-2018	88
Tier 2	ASA(Seconds)	09-01-2018	78
Tier 2	ASA(Seconds)	09-02-2018	98
Tier 2	ASA(Seconds)	09-03-2018	56
Tier 2	ASA(Seconds)	09-04-2018	67
Tier 2	ASA(Seconds)	09-05-2018	108
Tier 2	ASA(Seconds)	09-06-2018	92

[balaganeshv2201]

if u elaborate the formulae it will be helpful to answer 

[v-yulgu-msft]

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]

I have attached the calculation