Average Weighted on DAX - sumx

Hi all,

i'm struggling with an average, i translate below a similar example:

Salesmen Sales Duration Year Month

A 10 10 2019 1

A 5 20 2019 2

B 20 3 2019 2

expected results in a table with 2019 selected:

top salesmen

Salesmen Weighted Avg

A sumproduct(Sales,Duration)/sum(Duration)=6.6666

B 20

i tried this but doesn't work

Weighted Avg = sumx(source,source[Sales]*source[Duration])/sum(source[Duration])

Thanks in advance!

Cosmin

Anonymous

This should work:

Weighted Sales = 
DIVIDE( 
    SUMX(FactSales, 
            FactSales[Sales] * FactSales[Duration] ), 
    SUM ( FactSales[Duration] )
)

Forum Discussion