How can I create a calculated measure with fields that are located in different tables ?

[Eldad_Gabay]

Hello,

I’m trying to create a calculated measure in a payment table, the calculation is very simple, I need to take the payment amount and divide it by the FX rate that is coming from a daily currencies table, both of the tables are joined to the same explore, but It seems that I can’t do this because both of the measures are coming from different tables.
I’m trying to avoid a table calculation, I need to create a measure that will give me the payment amount in USD, I’m also tying to avoid using a derived table.
Any ideas ?!