Use same Top 10 limit in a chart for the main and alternative measure
I have a chart and I would like to show two measures main and alternative but use the same Limit totals for both measures.
The measures would be
1. Total measure value (The limit total is based on this measure)
2. Average measure value
The effect would be we see the same Customers and be able to swap between the measures. In my chart this isnt working when I choose the alternative measure it loses the top 10 ranking and so shows a different set of Customers.