Summarize Multiple Columns of Different Tables

[biengineer]

Dear All,

Hope you all are doing well.

I wish to Summarize based on different columns from different tables with Many - Many Relationship.

#Mcs = 
Var PorMins =AVERAGE(A[SMV])*SUM(B[Qty])
Var Avlmins = 480*25*0.65
Var Mcs1 = SUMX(SUMMARIZECOLUMNS(B[Art], A[Operation Title], A[Machine Type], "Mcsz", DIVIDE(PorMins, Avlmins)), [Mcsz])
Return
Mcs1

I wish to bring required Mcs into the Table B

Best Regards.  

[amitchandak]

@biengineer , you can create a new table in the table be

Divide(AVERAGEX(Related(A), A[SMV])* B[Qty], 480*25*0.65)

in case you need a custom to join use the table name and filter

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[biengineer]

Dear Sir,

I could not succeed. May you please help and checkout the file.

https://we.tl/t-XAMbWL3KEo 

Best Regards.

[biengineer]

Sir, Thanks for your help. But it does not sum up to actual value, I surrounded it by Sumx which gives wrong results.

#Mcs = DIVIDE(AVERAGEX(RELATEDTABLE(A), A[SMV])*SUM(B[Qty]), 480*25*0.65)