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?
Hi @thomassto14
Try this measure:
SalesValue = SUMX(VALUES(Table1[Customer]),CALCULATE(SUM(Table1[Sales])))
Hope this helps!
Could you please provide some sample data so that we can provide solution based on your table data?
Best Regards,
Herbert