Getting a measure from one table into another table if they're both related to the same third table

[miketondu]

Hello,

So I have a table_1 from which I'm building a measure to calculate cost.
I have another table_2 to which I want this cost measure to flow into.

Both of these tables are related to the calendar_table, but unrelated to each other.  How can I achieve this ?

I need the cost measure to be responsive to all the lookup table filters from table_2 that are connected to it.

Thanks for your help 

[amitchandak · Accepted solution]

@miketondu , You have to create additional common dimension, to make it responsive

https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

or use treatas to pass values

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/