Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I hope someone can help me to write a Measure in PowerBI to sum the Revenue for the distinct Customers.
The sum of the Revenue below is £80. Tom has two Tasks set (a and b), but I only want to sum the Revenue for Tom, i.e. Tom's revenue is £10, James' is £15, etc. The total sum for the Revenues for the distinct Customer should total £50.
Hopefully some wiz can advise a suitable answers.
Thanks.
Customer | Task | Revenue, £ |
Tom | a | 10 |
Tom | b | 10 |
James | c | 15 |
George | d | 20 |
James | e | 15 |
Harry | f | 5 |
Harry | g | 5 |
@Matthew You can do this by creating two Measures, the first supports the second.
First create the max value
Max = MAX(Table1[Revenue, £])
Then you can use SUMX to take that max value by distinct Customer
DistinctSum = SUMX(DISTINCT(Table1[Customer]), [Max])
Here is a breakdown of what it looks like in table next to other measures and your columns.