calculate sum between 2 tables

[jja]

Hi

I have a table Components which conist of component name, weight

then i have table Transactions where it stores different transactions of components. I have relationship between tables 1-*

I want to sum in a visual table the total weight of transactions the user made. I can sum the Processed qty but fail to sum Processed weight. i see if component has weight of 2 kg and has 3 different transactions and if i just multiply weight and qty each record return me 6 kg and then the overall sum is incorect

The table looks looks somehting like this:

User|Processed qty|Processed weight

what i am doing wrong? pls help

[calerof · Accepted solution]

Hi @jja ,

If you use this code you can calculate the total weight:

Total Weight = 
SUMX(
    Component_Transaction,
    [Quantity Total] * RELATED(Component[Weight])
)

With a transaction table like this:

This will be your result:

Hope it helps.

Regards,

Fernando

[jja]

thank you guys!!!!

[calerof · Accepted solution]

Hi @jja ,

If you use this code you can calculate the total weight:

Total Weight = 
SUMX(
    Component_Transaction,
    [Quantity Total] * RELATED(Component[Weight])
)

With a transaction table like this:

This will be your result:

Hope it helps.

Regards,

Fernando

[amitchandak]

@jja , Try measure like

Sumx(Transactions , [Processed qty]*[Processed weight])

[jja]

Hi @amitchandak 

Processed weight is a measure that i want to achieve and weight column is stored in Components table
Transactions table has qty column and Processed qty measure

[amitchandak · Accepted solution]

@jja , Hope I got the tables name right

Sumx(Transactions , [Processed qty]*  related(Component[Processed weight]))