Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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
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.
| Customer | Item ID | Total Sales |
| John Smith | 124568 | 63,258 |
| Mary Shelly | 124569 | 54,247 |
| Robert August | 124570 | 39,258 |
| Gene Campbell | 124571 | 71,269 |
| Amy Waters | 124572 | 40,123 |
| John Smith | 54789 | 21,000 |
| Mary Shelly | 789456 | 11,321 |
@jack1e
Can you please paste sample raw data, not as a image, and what is output you expect.
Please share
Proud to be a Super User! | |
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 52 | |
| 51 | |
| 35 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 92 | |
| 75 | |
| 41 | |
| 26 | |
| 25 |