create a new measure from two different columns from table indirectly related

[gusdcruz]

I want to mutiple column name Proportion from table Diet with column name DMI from table DMI, these tables are not connected directly but they are connected with a common table called "Tratamento". The Proportion and DMI changes on a daily  basis. Any suggestion on how to create a new measure, which mutiples Proportion by DMI on a daily basis?

[v-piga-msft]

Hi @gusdcruz,

It seems that you have created the relationships between the tables. 

Why not use the RELATED function to get the columns in different table in a measure?

If you still need help, please share some data sample and your desired output so that we could help further on it.

Best Regards,

Cherry