sum error when 2 columns of 2 table muliply

[Vincent_Jaquet]

Hello,

I try to Multiply 2 Columns of 2 differents table.

one is a Personal reference table  and the other is the hours done by project

I create a relation between the two table with the both column name

Costs = SUM('DATA'[Hours done]) * SUM('Personel'[Hourly rate])

hours sum are OK

But the sum of the cost are wrong

Thanks for your help

[amitchandak]

@Vincent_Jaquet 

Ideally for mutliplication you should use
Sum(A*B)
When that is not possible use the row context

Costs =
sumx(summarize(Project, project[ID],"_dat",SUM('DATA'[Hours done]) ,"_hrs",SUM('Personel'[Hourly rate])),[_dat]*[_hrs])

 if you need more help make me @

Appreciate your Kudos.

[Vincent_Jaquet]

Hello,

I try your code but I have exactly the same result

My both table are DATA and Personel

Costs =

SUMX(SUMMARIZE(DATA;DATA[Project];"_dat";sum(DATA[Hours done]);"_hrs";Sum(Personel[Hourly rate]));[_dat]*[_hrs])

[Vincent_Jaquet · Accepted solution]

It's ok the summurize must be done on Name and it's ok

Thank you very much for your help

[amitchandak]

@Vincent_Jaquet , that is what you could have found best. As I am not aware best of your data model. Kudos !!