Forum Discussion
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...
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.
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. :)
You are welcome.