Forum Discussion
Dynamic Weighted Average
I am trying to get the Average Price per month similar to the following. The average needs to change based upon the selection of the Location and Model slicers. Ultimately I need to be able to graph ...
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?