Row-wise calculation across non direct related tables

lhevora — Fri, 15 May 2020 14:20:16 GMT

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?

Re: Row-wise calculation across non direct related tables

Greg_Deckler — Fri, 15 May 2020 14:32:37 GMT

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

topic Row-wise calculation across non direct related tables in DAX Commands and Tips

Row-wise calculation across non direct related tables

Re: Row-wise calculation across non direct related tables