How to pick up a dimension from a table's colum to create a calculated expression in another column

[sdavinblanc]

I have one table in my sheet with three column :

- Column A is a dimension from my table_A : Analyse_Period (format YYYYMM)

- Column B is a measure from my table_A :  Amount_A

I would like to create a Column C which is a calculated expression like this : =[Amount ] / [X]

 [X] is an amount_B from table_B i would like to pick up using the period from my column A.

My expression could be : = Sum({<Period={Analyse_Period )}>}[Amount_B).

I know i can do it directly from the load script but i would like to know if it"s possible to do it directly in my visualisation ?

Thank you for your help

[Chanty4u]

Try this 

Sum(Amount_A)

/

Sum(

    {<Period = {"=$(=Only(Analyse_Period))"}>}

    Amount

_B

)

[sdavinblanc]

It doesn't work

There is no error detected in the definition of the expression but there is no result in my column.

[marcus_sommer]

If the relationship between the tables covers your requirements it should be possible to calculate such things within the UI whereby I assume that something will be probably more suitable:

if(Analyse_Period = Period, sum(Amount_B))