Calculating weighted average

Question

Need helpI 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&nbsp;SkillMetricDateValueTier 1Vol. Handled09-01-2018100Tier 1Vol. Handled09-02-2018130Tier 1Vol. Handled09-03-2018189Tier 1Vol. Handled09-04-201890Tier 1Vol. Handled09-05-201867Tier 1Vol. Handled09-06-201878Tier 1Vol. Offered09-01-2018110Tier 1Vol. Offered09-02-2018140Tier 1Vol. Offered09-03-2018199Tier 1Vol. Offered09-04-2018100Tier 1Vol. Offered09-05-201877Tier 1Vol. Offered09-06-201888Tier 1ASA(Seconds)09-01-2018120Tier 1ASA(Seconds)09-02-2018140Tier 1ASA(Seconds)09-03-201860Tier 1ASA(Seconds)09-04-201889Tier 1ASA(Seconds)09-05-201898Tier 1ASA(Seconds)09-06-201812Tier 2Vol. Handled09-01-2018130Tier 2Vol. Handled09-02-2018123Tier 2Vol. Handled09-03-2018167Tier 2Vol. Handled09-04-201889Tier 2Vol. Handled09-05-201867Tier 2Vol. Handled09-06-201878Tier 1Vol. Offered09-01-2018140Tier 1Vol. Offered09-02-2018133Tier 1Vol. Offered09-03-2018177Tier 1Vol. Offered09-04-201899Tier 1Vol. Offered09-05-201877Tier 1Vol. Offered09-06-201888Tier 2ASA(Seconds)09-01-201878Tier 2ASA(Seconds)09-02-201898Tier 2ASA(Seconds)09-03-201856Tier 2ASA(Seconds)09-04-201867Tier 2ASA(Seconds)09-05-2018108Tier 2ASA(Seconds)09-06-201892

v-yulgu-msft · Answer

Hi&nbsp;Anto123,
&nbsp;
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.
&nbsp;
Best regards,
Yuliana Gu

balaganeshv2201 · Answer

if u elaborate the formulae it will be helpful to answer&nbsp;

anto123 · Answer

I have attached the calculation&nbsp;

Forum Discussion

Calculating weighted average

3 Replies

Related content

Calculating Weighted Average

Calculating Weighted Sales

Weighted Average DAX

calculating weighted average

weighted average calculation

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