Could you please attach your sample data as TWBX format.
Due to the sensitivity of the data I cannot post, just wanting to see if anyone has any advice if this has been done before. I will try to recreate something later using a sample database... Thank you
Yes, I've done it and it is possible. Here is what I had to do:
For the 2 different measures, I created 2 separate parameters called "Measure 1" and "Measure 2". Make each parameter a listing of metrics/measures you would like to give the user the option to select. Each of those parameters will then feed a Calculated Field that will output whatever measure you want it to (Avg Sales, Total Revenue, etc). Setup this calculated field (calling it Measure1 Select) with either IF/THEN or CASE.
IF [Measure 1] = 1
ELSEIF [Measure 1] = 2
THEN SUM([Total Revenue])
Example (CASE Statement):
CASE [Measure 1]
WHEN 1 THEN AVG([Sales])
WHEN 2 THEN SUM([Total Revenue])
Do the same thing for your second measure in another calculated field called "Measure 2 Select".
Drag your Date field on to the Columns shelf. Drag [Measure 1 Select] and [Measure 2 Select] to the Rows shelf, right click on [Measure 2 Select] and pick the "Dual Axis" option. You can synchronize your axes if need be, etc.
Let me know if that works for you.