The use of RELATEDTABLE and RELATED

[bchager6]

Hello all...

Wondering if someone can confirm something for me: The following expression was written to store the total weight of an order, in to a SalesHeader table. Is the existance of the RELATEDTABLE (SalesDetail) portion of the expression there solely to propagate through to the Product table? 

SalesHeader[TotalWeight] = SUMX ( RELATEDTABLE ( SalesDetail ), RELATED ( 'Product'[Weight] ) * SalesDetail[Quantity] )

[mwegener · Accepted solution]

Hi @bchager6 ,

SUMX iterates through the Sales Detail rows belonging to the Sales Header and executes for each row the calculation Product Weight * Sales Detail Quantity.

I hope it helps

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[bchager6]

The explains it. Thank you!