Sum of Multiply Column from Different Table

[Anonymous]

Hey, so I have three tables called Project, Timesheet, and Parameter. The Project has one to many connection with Timesheet. I need to have a measure that calculate the sum of the multiplication of Timesheet[allocation] and Parameter[numbervalue] for each project. However, I can't seem to achieve that using SUM or SUMX. Is there any way I could achieve that? Thank you in advance!

[amitchandak · Accepted solution]

@Anonymous , selected value of Parameter[numbervalue] or min/max value

If selectedvalue then

a new measure

measure =

sumx(Timesheet, Timesheet[allocation]* selectedvalues(Parameter[numbervalue]) )

If with Min or max or with any join logic a new column

new column =

Timesheet[allocation]*min(Parameter[numbervalue])  // Min or Max or sum

refer if needed

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