cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eijer Regular Visitor
Regular Visitor

Measure summarizing by group

I want to create a measure that adds up the sales amount of each salesperson. Please refer to the example below. The name of the table is Sales.

 

PriceSales-man
100John
100Michael
200Ron
300Juile
100John
200John
1 ACCEPTED SOLUTION

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: Measure summarizing by group

Hi @eijer ,

 

Drag [Price] and [Sales-man] into a Table visual, it will sum up the sales amount per salesperson automatically.

1.PNG

 

Additionally, you could refer to below measure.

Sum price = SUM(Sales[Price])

2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
um_mir Frequent Visitor
Frequent Visitor

Re: Measure summarizing by group

Hi @eijer 

 

Try below measure

 

TotalPrice = SUMX(Sales,Sales[Price])
 
Hopefully this works for you.
eijer Regular Visitor
Regular Visitor

Re: Measure summarizing by group

@um_mir 

 

Thanx for your help, howerver; it wasn't I wanted.

 

A formula is required to obtain the sum of the sales figures for each salesperson.

v-yulgu-msft Super Contributor
Super Contributor

Re: Measure summarizing by group

Hi @eijer ,

 

Drag [Price] and [Sales-man] into a Table visual, it will sum up the sales amount per salesperson automatically.

1.PNG

 

Additionally, you could refer to below measure.

Sum price = SUM(Sales[Price])

2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 125 members 1,432 guests
Please welcome our newest community members: