Forum Discussion
Variable in measure based on slicer selection
Hello dear community, Merry Christmas to all. I hope you are well. I have a question. I have different simple measures per country to convert the currency. I would like that when I select th...
Hi Anonymous
There are several options to work with FX rates, but just check one solution here:
https://www.dropbox.com/s/h8kqqr1emeg96tr/slicer_devise_%28allure-analytics.com%29.pbix?dl=0
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
negi007
Community Champion
Community ChampionAnonymous let's say you have table below which has country name and conversion value
you can then create a measure that will extract the rate from the above table basis selection in the slicer for a country
Currency_convertor =
var country_selected = SELECTEDVALUE('CURRENCY'[country])
return
LOOKUPVALUE('CURRENCY'[rate],'CURRENCY'[country],country_selected)
in the above visual, you can see basis selection value is being shown from table. You can customize the measure above to get the final value by calc using measure