Can't multiply 2 columns from 2 different queries

[Bratone]

Hello,

I have the below model and I am trying to creature a measure which for every employeed, will multiply in every day of the week the Duration from the file query "RAR" with the related target from the querry called "Dynamic Target".

The thing is that I tried doing the same but taking the target from another query and it's working, to sum it up below:

A  = SUMX(RAR, [Total Annotation]* RELATED(Activities[Target])) ==> WORKING

B = SUMX(RAR, [Total Annotation]* RELATED(?????) ==> Here it doesn't find the related Target in the "Dynamic Target" query.

Both files, "Activities" and "Dynamic Target" have the same kind of connection to the RAR query (through the "Process Name"), yet for the "Activities" one it lets me multiply with the target from there, but for the "Dynamic Target" it doesn't, can you please explain me why ?

Also, I tried doing the below formula as well:

A = SUMX('Dynamic target', [Total Annotation] * 'Dynamic target'[Target]) ==> it works, so in the "Dynamic target" query I can multiply these, but for some reason the result is doubled, so for example, instead of 50 I get 100 etc.

This is also how the queries look inside, if you need more info or pictures please let me know...

So as you may have guessed from the pics, the idea is to use a dynamic target which can change from one day to another or from one employee to another (the excel file for the query will have a dedicated sheet for each week of the year, with the list of days, employees etc), rather than use a general one from the Activities query.

Thank you very much for your help!

[Bratone]

Thank you very much @amitchandak, it worked with relatedtable.

[amitchandak · Accepted solution]

@Bratone , RELATED can only give one side of table data to many side, for tables directly connected

You can try Related table or Sumx/Maxx with your choice of condition

example

New column in table 2

maxx(filter(Table1, Table1[ID] = Table2[ID]), Table2[Value])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8