Row-wise calculation across non direct related tables

[lhevora]

Hi,

I am trying to row-wise calculate a value using two columns available in my dataset. The problem is that the columns I need are in tables that are not directly related.

This is what I have:

and this is what I would do if the columns were in the same table:

measure = SUMX(main_table; main_table[IL_30d] * main_table[_Estoque_Cedente]) / sum(main_table[_Estoque_Cedente])

I cannot just simply connect both tables since the relations I have in the model are more complex than I am showing. The column Cedente_Documento is the key between il, concentracao and cedentes tables.

Is it possible to do what I need using DAX?

[Greg_Deckler]

So generally you are going to use RELATED or RELATEDTABLE in those kinds of situations.