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, I have a calculation issue - I had an order transation table that had 1 line for each order and Total Item Amt and Total Shipping Amt. But it did not have the item detail. So I merged the item line detail with the order table but now I have duplicate shipping amounts.
My thought was to count the number of items in each order and then divide by the total shipping to get an average shipping per item.
Shipping Cost divided by Item count =
DIVIDE(SUM('Items Ordered'[Shipping Cost]), [Item count])
In the above data I started with the left set, merged to create the middle set, and I want the output to be on the right set of data. I have gotten the calculation to work but it doesn't sum correctly.
Solved! Go to Solution.
Hi @jpt1228,
How did you do it? Can you share your file or a dummy sample? Please check out the demo in the attachment.
Best Regards,
Dale
Hi @jpt1228,
How did you do it? Can you share your file or a dummy sample? Please check out the demo in the attachment.
Best Regards,
Dale
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |