Why is R2 multiplied by 90%, to change 3.5 to 3.15?
Assuming that's an error, and you actually want the average of each rate multiplied value for the selected categories, per calendar date, then you can use a couple of measures:
You can then filter Category items in your visualisation - or if you really want a single measure, then something like:
Edit: added workbook, with required output in a pivot table, in Q5. You'll notice I've added a Calendar table, and a Category dimension table to the model... these aren't strictly necessary for the above measures to work, but they make reporting easier.
Bookmarks