Forum Discussion
Variable in measure based on slicer selection
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 !!!
Thnak you to you negi007 and ALLUREAN for your idea. It help me a lot.
I have a question based on that.
Imagine that I have a simple measure (if sales amount are between 1M and 2M then 1 if not0).
Is it possible to do this :
If I select Country the divide simple mesure by the disctinct count of country. If I choose region divide by distinct count of region, ... )
Do I do every time a measure for each case ?
Solution SageЗдраствуй Anonymous
You can download the file again. In this case the measure is using distinct static number of countries/regions, it can be dynamic if this is the case.
Hello Sir,
Thank you for your answer but I can't download the file :
Site is unreachable
- ALLUREAN