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...
HI zina-aziz,
Sure, you can create a measure based on the selected value in slicer. But you should build a relationship between the two tables. Which means there should be some same columns in the two tables and values in one of the column need to be unique.
Please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Regards,
Jimmy Tao