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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

In this report i am filtering the data Month follow with SKU then Importer name. Once will select the Importer name. then i applied the Sumproduct formula to find WA

eg : =SUMPRODUCT($P$5446:$P$5585,$I$5446:$I$5585)/SUM($I$5446:$I$5585)

 

  

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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for your support i will apply the same DAX Formula as you suggested.