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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

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
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.