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!View all the Fabric Data Days sessions on demand. View schedule
Hello,
thank you for helping with my little Problem. I have customer and some customers together forms a group. It easy to calculate sales for each custumer with a measure or a calculated coloum. How can I calculate the sales for the whole group (group sales)?.
| cust. nr. | group | solo sales | group sales |
| 10 | A | 10 | 40 |
| 11 | A | 10 | 40 |
| 12 | A | 10 | 40 |
| 13 | B | 10 | 30 |
| 14 | B | 10 | 30 |
| 15 | A | 10 | 40 |
| 16 | C | 10 | 10 |
| 17 | B | 10 | 30 |
Solved! Go to Solution.
@Stever25
Try,
If you are adding a column then:
sum(table[solo])
for Meaure,
calculate ( sum(table[solo]) , all(table[group]))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!