Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |