Combine a Parametric slicer with another slicer - one for Metric selection and the other for Period

[rnambiar]

I have 2 slicers as shown below: 

1.  Metric 

2.  Period

I have a combination Line/Bar chart as follows.  The Metice slicer is Parametric slicer and works fine.  I'd like to be able to combine the Period Slicer with the Metric Slicer such that when Revenue is selected and Period is selected the relevant values for Revenue are displayed i.e.

1.  Revenue + Month = display revenue for the month, 

2.  Revenue + YTD = display YTD revenue for the month (in the bar for the month) and so on.

Below is the code for the Slicer (Parametric).  This works fine and I am able to switch between the various Metrics without a problem.

Metric = {
    ("Revenue", NAMEOF('FSMeasures'[Revenue]), 0),
    ("Gross Profit", NAMEOF('FSMeasures'[Gross Profit]), 1),
    ("Net Profit", NAMEOF('FSMeasures'[Net Profit]), 2)
}

For the Time Intelligence slicer, I created a table as follows:

Period  Order

Month	0
YTD	1
TTM	2

The dax code I used to switch between the Periods here is:

Period = 
VAR P1 = SELECTEDVALUE('Table'[Order])
VAR M1 = SELECTEDVALUE(Metric[Parameter Fields]) 

VAR Result = 
            SWITCH(P1,
                0, M1,
                1, TOTALYTD(M1,DATESYTD('Calendar'[Date]),"12/31"),
                2, CALCULATE(M1,
		DATESINPERIOD('Calendar'[Date],MAX('Calendar'[Date]),-12,MONTH)
		),
                99999
            )

RETURN
    Result

The result I am getting is:

Any help is greatly appreciated.

[lbendlin]

Sooo much effort.  Instead, enable "Personalize Visuals"  and teach your users how to use it.

[parry2k · Accepted solution]

@rnambiar this is not possible:

VAR M1 = SELECTEDVALUE(Metric[Parameter Fields]) 

For Time intelligence create a calculation group and in the calculation group use selectedmeasure() and that I think will do it.

[rnambiar]

YEs the calculation group worked