Forum Discussion
Currency Filtering
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
Anonymous - thank you for trying to help, appreciate that.
However, I don't think I follow. Below is the sample data. Maybe this would help?
The issue I have now that calculated column "Inv_Amount_Calculated_FX" is not multiplied by a measure "FX_Rate".
Measure "FX_Rate" depends on Entity selected in a slicer "Entity" and depends on a choice in slicer "Select_Currency".
My expected result would be that values in a column "Inv_Amount_Calculated_FX" are multiplied by measure "FX_Rate".
thanks a lot!
Dataset_01
Dataset_02
Dataset_03
Hi Anonymous ,
I create a sample using you sample data, and I change your calcuated column to measure, it works:
New Amount = SUM('Table'[Amount]) * [FX_Rate]Aiolos Zhao