cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bchager6 Member
Member

The use of RELATEDTABLE and RELATED

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] )

 

Capture.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
mwegener New Contributor
New Contributor

Re: The use of RELATEDTABLE and RELATED

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 answer you question, please mark my post as solution, this will also help others.

Please give Kudos for support.

View solution in original post

2 REPLIES 2
mwegener New Contributor
New Contributor

Re: The use of RELATEDTABLE and RELATED

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 answer you question, please mark my post as solution, this will also help others.

Please give Kudos for support.

View solution in original post

bchager6 Member
Member

Re: The use of RELATEDTABLE and RELATED

The explains it. Thank you!

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,546)