Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    Then my original DAX formula should give the exct result.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 
Still random! are you sure the DAX formula outcome is not correct?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yes still their is some difference in WA, As suggested i have applied the below formula but  number is not matching  

Weighted Average =
VAR CurrentTable =
CALCULATETABLE (
'Data 22',
ALLEXCEPT ( 'FData 22', 'Data 22'[IMPORTER NAME], 'Data 22'[SKU], 'Data 22'[MONTH], 'Data 22'[YEAR] )
)
RETURN
DIVIDE (
SUMX ( CurrentTable, [MT Vol] * [Rate Per FSU] ),
SUMX ( CurrentTable, [MT Vol] )
)