Forum Discussion
Dynamic Weighted Average
v-juanli-msftI have updated this post becuase what I thought didn't work in the solution seems to work fine. However, the key is that I am going to want to be able to put this in a chart and graph by month with a totla price per month...not by model. When I select multiple months this does not seem to work.
I have also found that if you add a third model for NY in Jan that count will be included in the total count even if not selected in the slicer.
Hi admiralman
If you want the Totalcount calculates based on selections of "Location","Month","Model", then you can use this formula, but it will calculate Totalcount for each row.
I would suggest you to give some expected results, then I can work directly for the purpose.
Best Regards
Maggie
I added a third model to show things a little more clear. As you can see, if I select all Models then the weighting, weightedcost2, and the total are what I would expect to see. However, if you only choose two models as in the second image things go askew. The total count continues to include the Prius even though filtered out by the slicer. Thus throwing off the weighting and the weightedcost2. If you graph this you will see the same result. I would expect the totalcount1 in image two to be 21 instead of 33 when only the Challenger and Malibu are selected.
Anyone know if this is possible?
