group by customer and sum value

[thomassto14]

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?

[SabineOussi]

Hi @thomassto14

Try this measure:

SalesValue = SUMX(VALUES(Table1[Customer]),CALCULATE(SUM(Table1[Sales])))

Hope this helps!

[Yokimi]

Hello @SabineOussi

You are my saviour! 

Thank you

[v-haibl-msft]

@thomassto14

Could you please provide some sample data so that we can provide solution based on your table data?

Best Regards,

Herbert