Forum Discussion
Currency Filtering
Hi Anonymous ,
I think there are some steps you need to do:
1.create a new column in table for USD Amount, then you will have 2 columns, one for local amount, one for USD amount.
2.create a table with one column named "currency code" which have 2 values, Local and USD
3.create a measure, like : if(max(currency code) = 'Local', sum(your_local_amount),sum(your_USD_amount_column))
Please try it.
Aiolos Zhao
Anonymous thank you for quick response!
1. Done
2. Could you please explain further? Something like this?
-----------------
Currency Code
-----------------
Local
USD
Ok I guess it was not the best solution, but I did some workaround.
- I have a slicer that has two options (local currency or usd)
- I have a measure that is showing either the USD FX for local currency or 1 if selected local currency (depending which option we choose in the above-mentioned slicer)
- I have created a new column that is supposed to multiply invoice amount by this measure, but for some reason, it is not working...
does anyone have any idea why?
Hi Anonymous ,
I created a sample data, and I assumed that you have below data:
And the measure calculates the USD amount,
so after you have that slicer(Local / USD),
you can create a new measure like:
if(max(slicer) = 'Local', sum(amount), my_measure)
Please try.
Aiolos Zhao