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! | |
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 52 | |
| 34 | |
| 33 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 61 | |
| 60 | |
| 39 | |
| 26 | |
| 24 |