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.
Dear Tamerj,
Thanks for the update, As i have applied the fourmula which you provided but still i am not getting the exact value.
tamerj1
Community Champion
Community ChampionHi Anonymous
Can you please advise what is the formula that you have used in excel for the numerator and the denominator?
tamerj1 To get value i am using Sumproduct formula- =SUMPRODUCT(MT*FSU)/SUM(MT)
- tamerj1
Anonymous
Apparently some of the provided information is no accurate. Are you sure you are filtering by month as well? As the sample screenshot does not say so. Please share the sample Excel file in order to verify exactly how the calculation is supposed to be handled. Thank you