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.
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.