Multiply columns from three different tables with 1-column relationship in between each table

[ialayidi]

Hello, 

I'm trying to multiply 2 columns from 3 different tables with many-to-many 1-column relationship between tables 1&2 and 1&3 (Tables 2&3 have the 2 columns being multiplied). I cannot change the data tables to integrate or add columns to simply the problem. The equation below is the one in use, but receving message "The column 'ILLM_DRT[TOTAL_DT]' either doesn't exist or doesn't have a relationship to any table available in the current context." I tried to merge tables 1&2 together to simplify, but it would not operate due to data size. I'm stuck here and need some help. Thanks! 

Downtime Cost = SUMX(V_PROD_COST_VS_VALUE, V_PROD_COST_VS_VALUE[FIXED_OVERHEAD_COST]*RELATED(ILLM_DRT[TOTAL_DT]))

[Anonymous · Accepted solution]

Hi @ialayidi ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Measure = 
var tmp=RELATEDTABLE(Table3)
var tmp1=RELATEDTABLE(Table2)
var tmp2=CROSSJOIN(tmp,tmp1)
return
SUMX(tmp2,[POINT]*[value])

I have also found a similar post, please refer to.

Solved: Multiplying Columns In Different Tables With Relat... - Microsoft Fabric Community

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.