Forum Discussion

admiralman's avatar
admiralman
Icon for Advocate II rankAdvocate II
8 years ago

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 ...
Need Help
admiralman's avatar
admiralman
Icon for Advocate II rankAdvocate II
8 years ago

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.

admiralman's avatar
admiralman
Icon for Advocate II rankAdvocate II
8 years ago

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.