Make report interactive: Send parameter from a menu to DAX /Measure

[Rygar]

Dear Community,

i would like to have a Menu or something like this in my report to make a Measure/DAX more flexible/interactive.

Example: 

Quantity x Months ago = CALCULATE(SUM(Sales[OrderQuantity]),DATEADD(dDate[Date],-1,MONTH))

Here -1 is fixed.

In the published report, the user should be able to choose to go back 1, 2 or 3 months back. So a menu with a list of Values (1..3) would be fine. This menu should pass its selection to the Measure. Is this possible?

Note: I found this solution, but this sends a parameter to Power Query and is not accessible in the published report.

Regards, Michael

[PaulDBrown]

Create a new table to use as the slicer to select the month number using the New Table function under Modeling in the ribbon with:

Select Month = {1, 2, 3}

Create the slicer with the single select option in the formatting pane.

Create the following measure:

 Month =SELECTEDVALUE (Select Month[Value]) *-1

now substitute the hard coded -1 in your measure with the [Month] measure

[Rygar]

Thanks a lot for that great Idea!

Unfortunately, inserting the measure into my expression shows no effect. Hard coded value does. 

I also tried to put the [Month] measure into VALUE() to make sure its a number, but still no effect.

Here ist the testfile. Any suggestion? 

[PaulDBrown · Accepted solution]

Well that was weird. Checking out your file, the measure was indeed unresponsive. I've deleted and created the parameter table, selection measure etc and it now works:

I've attached the sample file

[Rygar]

Hey Paul, thats great, thank you very much!