Forum Discussion
Subtotal bar chart with measure
Hi, I created a dashboard with built-in dynamic switch to show the top and bottom 5, 10, and 15 performers by vendors and region (similar to this dashboard). Based on the dashboard link, Tota...
v-jiascu-msft I'm not sure what happened with the other post. I've uploaded the PBIX file in the original post in Dropbox. You can download the file by clicking on the link.
Thank you.
MattAllington I tried your suggestion, but only got the total, not subtotal of what's being shown on the screen.
Measure = CALCULATE ('Measure' [Measure Selection], 'Top'[Select View])
'Measure' is the switch statement for total savings and total spend
'Top'[Select View] is the filter for 5, 10, 15