Forum Discussion

Post Partisan

7 years ago

Solved

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...

Anonymous

7 years ago

This should work:

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

Anonymous

Not applicable

7 years ago

This should work:

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