Average Weighted on DAX - sumx

[cosminc]

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 · Accepted solution]

This should work:

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

[cosminc]

Hi,

it doesn't work unfortunately

it gives me same value for each Salesmen

Thanks

[Anonymous]

Hmm. Looks like it works for me?!

[cosminc]

it works

my mistake

after 2 hours i realised that i made a column instead of a measure...

Thanks!

Cosmin