Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
jack1e
Frequent Visitor

Help please

Hello I am trying to get the total sales per customer. I have tried  samples from many sources but nothing that gives me what I need. I am ultimately trying to get a weighted profit margin but first I need to know total sales for each customer. I have included my sample which is much smaller than the original but with some of the same data. Thank you in advance

jack1e_0-1661800796664.png

 

2 REPLIES 2
jack1e
Frequent Visitor

I would like for BI to sum total sales by customer. This is just a sample and my file is much bigger than this but this will give  you an idea of what I am trying to do.  

CustomerItem IDTotal Sales
John Smith12456863,258
Mary Shelly12456954,247
Robert August12457039,258
Gene Campbell12457171,269
Amy Waters12457240,123
John Smith5478921,000
Mary Shelly78945611,321
PijushRoy
Super User
Super User

@jack1e 

Can you please paste sample raw data, not as a image, and what is output you expect.

Please share




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.