Forum Discussion

Sonnet's avatar
Sonnet
Icon for Helper I rankHelper I
3 years ago

Using ISSELECTEDMEASURE to navigate to two different drill through pages

Hi, I have a main page for the report and two for drillthrough. I am using the following measure on the action of a button to navigate to different drill through pages if I select a visual with one m...
DAX
Drill-through
ISSELECTEDMEASURE
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago
Sonnet  I hope this helps you!!Thank You!!
Drillthrough filter =
VAR SelectedMeasure =
SELECTEDVALUE('Risk'[Selected Measure])
RETURN
SWITCH (
SelectedMeasure,
"Mitigated Risks", "Page 5",
"Total Open Risks", "Page 4",
""
)

Sonnet's avatar
Sonnet
Icon for Helper I rankHelper I
3 years ago

Thank you for your help. When I use your measure, the SelectedValue function wants a column. You use '

'Risk'[Selected Measure] 

what is  'Selected Measure'?

Meanwhile, I am trying to play with your measure, trying to find a working way.