Forum Discussion
Weighted Average DAX Expression
Dear All, i have list of multiple category to calculate Weighted Averages, to calculate Weighted avg first i have to filter Month, SKU, then Traders In excel. i applied Sumproduct formula and i am g...
Anonymous
Then my original DAX formula should give the exct result.
tamerj1
Community Champion
Community ChampionHi Anonymous
please try
Weighted Average =
VAR CurrentTable =
CALCULATETABLE (
'Table',
ALLEXCEPT ( 'Table', 'Table'[Traders Name], 'Table'[SKU], 'Table'[Month] )
)
RETURN
DIVIDE (
SUMX ( CurrentTable, [SumMillion Ton] * [Rate Per] ),
SUMX ( CurrentTable, [Million Ton] )
)Dear Tamerj,
Thanks for the update, As i have applied the fourmula which you provided but still i am not getting the exact value.