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

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

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 40 members 868 guests
Please welcome our newest community members: