cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eijer Frequent Visitor
Frequent 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
Community Support Team
Community Support Team

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

Community Support Team
Community Support Team

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.