1 of 1 people found this helpful
You want to create a Parameter "Size" with values "total revenue" and "number of customers", then create a calculated field along the lines of:
IF [Size] = "total revenue" THEN [Total Revenue]
ELSEIF [Size] = "number of customers" THEN [Number of Customers]
(The CASE...WHEN syntax will accomplish the same thing and may be preferable depending on how many options you have.)
You can accomplish this with a parameter and a calculated field. I've attached a sample workbook that has done this for a dimension but the concept is the same for a measure.
Your parameter lists out the measures to choose from, and the calculated field goes on your viz as the measure.
Let me know if you have questions.
Book1.twbx 1,020.6 KB
Thanks for the quick responses! I'll try this out.
EDIT: This solved my issue perfectly. Thanks again!