Perhaps overkill here, but you could set up a calculation group to dynamically substitute other measures for [Total Sales] in @jpratt’s suggested measure.
Might be worth doing however as a good learning opportunity on Calculation Groups and Tabular Editor.
- Brian