Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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] )
Solved! Go to 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.
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.
The explains it. Thank you!
User | Count |
---|---|
102 | |
91 | |
87 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |