Forum Discussion
group by customer and sum value
Hi i create a report with Filled map and when i click the country i want, i have at the right a table with all customers of this country and salesvalue off them. I would like to summarize salesvalue in group by each customer. How can i do this in PowerBi?
4 Replies
SabineOussiSkilled Sharer
Hi thomassto14
Try this measure:
SalesValue = SUMX(VALUES(Table1[Customer]),CALCULATE(SUM(Table1[Sales])))
Hope this helps!
v-haibl-msftMicrosoft Employee
Could you please provide some sample data so that we can provide solution based on your table data?
Best Regards,
Herbert
- nicoenz
Helper III
hallellujah!!!!!!!
