Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi: I have a dataset with 50K records in it. Some of those records have duplicate IDs, leaving only 47K unique values, they just have a different employee attached to them thus resulting in a duplicate ID. I'd like to create a card on my dashboard that shows the total revenue, while not double counting the duplicate records. Example table below. With this example the card would ideally display 14,500, only summing the revenue column for the first instance of a Deal ID. I thought it should be simple but I've tried other solutions posted on this forum with no luck. Thanks.
Deal ID Revenue Employee 12345 1,000 Jon Smith 12345 1,000 Bill Jones 12346 12,000 Jon Smith 12555 1,500 Jane Doe 12555 1,500 Michael Scott
Solved! Go to Solution.
You probably want to do something like:
Measure = SUMX(SUMMARIZE(Table,[Deal ID],"__Revenue",AVERAGE([Revenue])),[__Revenue])
You probably want to do something like:
Measure = SUMX(SUMMARIZE(Table,[Deal ID],"__Revenue",AVERAGE([Revenue])),[__Revenue])
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |