Slicer Selection Summing

[fjameshagan]

Teammates!

I have been looking for an answer to this question all over. I have a very large data set that rolls up to 5 different Sales Directors. The slicer selections help navigate through all of the pages and visualizations for each Sales Director, but what I need is the ability for the Select All function of the slicer to sum all of their revenues, targets, rankings, basically every measure I have broken out at the SD level I need at a total region level. Can anyone offer any advice?

[v-chuncz-msft]

@fjameshagan,

The requirement is not very clear. Share a complete exmaple if possible.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#selection-controls-...

[fjameshagan]

Hope this helps. This is the net revenue delivery by one of our Sales Directors. You can see the actual amount, goal amount, and gain or gap. In the second photo you can see I've selected two Sales Directors and instead of summing the two totals together and showing 700 million, it only shows the most recently selected SD's number. Do you know how to fix this? I want to be able to select all SD's and get a total region number.