Forum Discussion

slashfemme's avatar
slashfemme
Icon for Helper I rankHelper I
8 years ago
Solved

Help! :( Dynamic Weighted Average based on Revenue

Hello all!   I've been so stumped by this all day and it is driving me nuts, given how easy it is for me in Excel. Basically what I am trying to do is weight the average selling price of my items b...
Need Help
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    For the Weighted Amt, the measure should be:

     

    =IF(HASONEVALUE(Data[Prod]),[Price] * [% of Total],SUMX(SUMMARIZE(VALUES(Data[Prod]),Data[Prod],"ABCD",[Price] * [% of Total]),[ABCD]))

     

    Hope this helps.

slashfemme's avatar
slashfemme
Icon for Helper I rankHelper I
8 years ago

Thank you so much for clarifying! Now this function makes sense to me, and I can't wait to use it elsewhere now that I know how to use it. :)

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

You are welcome.