Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |