cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thomassto14 Frequent Visitor
Frequent Visitor

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?

3 REPLIES 3
v-haibl-msft Super Contributor
Super Contributor

Re: group by customer and sum value

@thomassto14

 

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

 

Best Regards,

Herbert

Highlighted
SabineOussi Established Member
Established Member

Re: group by customer and sum value

Hi @thomassto14

 

Try this measure:

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

 

Hope this helps!

Yokimi New Member
New Member

Re: group by customer and sum value

Hello @SabineOussi

You are my saviour! Cat Very Happy

Thank you