Dynamic measure values based on slicer selection

[zina-aziz]

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 from another table as shown below:

So for example, if i create an average rate card, when i select different currencies, the figure in the card will adjust depending on the rates in the second table.

Is such a measure possible? If so, how would you go about creating it?

Any help would be much appreciated.

Zina

[theov]

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

https://www.youtube.com/watch?v=tljRYGz15PA

[v-yuta-msft]

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

[quentin_vigne]

Hi,

Here is what you are looking for : 

https://community.powerbi.com/t5/Community-Knowledge-Base/Dynamic-column-based-on-slicer-selection/t...

Quentin

[donsvensen]

Hi 

Here is a good example on how to do that

https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/

made by @GilbertQ

/Erik