Presentation variables

[Anonymous]

can we capture the values form dashboard prompt in variable and pass it to the underlying report of the Column formulas

for example I want to build something like this
case when Month is selected filter (measure using Month between start month and end month)
case when Quarter is selected filter (measure using Month between start Quarter and end Quarter)
Else select YTD

[rajulshah]

Hello @Anonymous,

You can create a hardcoded table containing values : "Monthly","Quarterly" and "Yearly".

and a measure is to be created as :

Measure = IF ( ISFILTERED(Table[Column]) && SELECTEDVALUE(Table[Column])="Monthly",[Your Monthly measure],

                        ISFILTERED(Table[Column]) && SELECTEDVALUE(Table[Column])="Quarterly",[Your Quarterly measure],

                        [YTD Measure])

Hope this helps.

[Anonymous]

How can we equate ISFILTERED(Table[Column]) = Monthly .. what I understand is ISFILTERED(Table[Column]) is the Month column from the Calendar Dimension

[rajulshah]

Hello,

Table[Column] is the column from the new hardcoded column, and here, we arent equating with ISFILTERED function but with the SELECTEDVALUE function.

Let me know if it still doesn't work.