Multiplication among different columns of tables in Analysis Services

[Anonymous]

Hello world, 
I have this table:

so I want to make a calculation of the conversion rate with YTD balance end for each combination. 
The problem is that I want this to be stable even without the aggregation of GL Combination, so that the summary takes the correct conversion rate per combination. 
The tables that data are coming are
GL Currency - "Fact - Balances"

GL Code Combination - " Dim - GL Code"

USD Conversion Rate - "Dim - Conversion"

YTD Balance End - "Fact - Balance" (it is a calculated measure as it comes from the analysis server)
I have tried through the :

Translated Amount = sumx(filter('Fact - Balance',[YTD Balance End]<>BLANK()),[YTD Balance End]*RELATED('Dim - Conversion'[USD Conversion Rate - Corporate]))

but unforunately this doesn't work.Any ideas?

[amitchandak]

@Anonymous , what is the error it is giving. related only work with 1 to M relation copy data from 1 to M side

[Greg_Deckler]

@Anonymous - A little hard to follow, see if these help. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

If not, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

So, as unfortuantely I cannot share a workbook as it is in Analysis services, the explanation would be like this:
I have the currency of a ledger in a column coming from a table named "Fact - Balances". 
I have the USD Conversion Rate in a column of a table named  "Dim - Conversion"
I have the amount of the transaction YTD Balance End in a table named "Fact - Balance" (it is a calculated measure as it comes from the analysis server)
I have the unique identifier (GL Code Combination) of the transaction in a column of the table named  " Dim - GL Code"

How can I multiply the YTD Balance end, with the USD Conversion Rate for each GL Combination according to the Currency of the ledger?
Thanks @Greg_Deckler  and @amitchandak  in advance.