cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jpt1228
Post Patron
Post Patron

Line total not correct due to repeating values per Order Number

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.

 

PBI Count and Divide.JPG

 

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.

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft
Microsoft

Hi @jpt1228,

 

How did you do it? Can you share your file or a dummy sample? Please check out the demo in the attachment.

Capture

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-jiascu-msft
Microsoft
Microsoft

Hi @jpt1228,

 

How did you do it? Can you share your file or a dummy sample? Please check out the demo in the attachment.

Capture

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors