Forum Discussion
Currency Filtering
Hello Everyone, I was searching forum, but didn't find a solution to my issue. I have a table "BDR Dataset" in Power BI Desktop that contains multiple companies, therefore multiple currencie...
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