Forum Discussion
Dynamic measure values based on slicer selection
Hi everyone, I have a spreadsheet with hotel rates and locations as shown below: I require a measure which can switch between three options from a slicer (Ie: AUD, GBP, USD) using data fro...
You can create a parameter hosting the options with datatable, no need for relationship with other tables.
Have your measures ready for each option and then use SWITCH and SELECTEDVALUE together and nest your measures inside.
This video explains it in two ways thoroughly