That looks like it works for the measure, but I also need the x-axis categories to change based on the RTM selected. .
Here's a simple example:
RTM Column A Column B Revenue Indirect
Company W 10
Company B Company X 20 Indirect Company C Company Y 30 Direct Company D Company Z 40
If someone chose RTM=Indirect, then the x-axis would show Company A and Company C and y-axis would show revenue of 10 and 30 respectively.
If someone chose RTM=Direct, then the x-axis would show Company X and Company Z and y-axis would show revenue of 20 and 40 respectively.