Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Presentation variables

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 f...
Need Help
Show and Tell
rajulshah's avatar
rajulshah
Resident Rockstar
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    7 years ago

    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.