Forum Discussion
qthuynh
8 years agoFrequent Visitor
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...
MattAllington
Community Champion
8 years agoWhat you need to do is write a new measure that returns the total revenue without the top 5 filter applied. From there it is a simple division.
So you have a top 5 list of something. You need to remove the filters on that “something”
The general pattern to do this is a measure something like this
CALCULATE([Total Revenue], ALL(Table))
where table is the one that filters your original visual by rows. So if you are showing top products, the use the products table.