cancel
Showing results for
Did you mean:
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.

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

Accepted Solutions
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.

Additionally, you could refer to below measure.

`Sum price = SUM(Sales[Price])`

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.
3 REPLIES 3
Frequent Visitor

## Re: Measure summarizing by group

Hi @eijer

Try below measure

TotalPrice = SUMX(Sales,Sales[Price])

Hopefully this works for you.
Regular Visitor

## Re: Measure summarizing by group

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.

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.

Additionally, you could refer to below measure.

`Sum price = SUM(Sales[Price])`

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.

Announcements

#### Challenge: Can You Solve These?

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

#### Community News & Announcements

Get your latest community news and announcements.

#### 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.

#### Win Power BI Swag with Community Kudopalooza!

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

Top Kudoed Authors
Users Online
Currently online: 125 members 1,432 guests
Recent signins: