cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Measure for total sales by sales group

I need to find the sum of total sales by sales group so that I can compare what portion of the total sales each sales rep accounts for.

 

In the example below, I need the calculation for the group sales column but I also need to make sure that it groups by the Sales Group because there are other Sales Groups in the dataset

 

EmployeeSales GroupSalesGroup SalesPortion of sales

Bob

Sporting Goods155030%
JaneSporting Goods155030%
JohnSporting Goods205040%
1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

@Turf03 

you can try to create two columns

Column = CALCULATE(sum('Table'[Sales]),ALLEXCEPT('Table','Table'[Sales Group]))

Column 2 = 'Table'[Sales]/'Table'[Column]

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
Super User II
Super User II

@Turf03 

you can try to create two columns

Column = CALCULATE(sum('Table'[Sales]),ALLEXCEPT('Table','Table'[Sales Group]))

Column 2 = 'Table'[Sales]/'Table'[Column]

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

@ryan_mayu Thats perfect!

 

Got another one for you. 

 

How would I determine the average sales per sales group? I'd like to compare their sales to the average.

@Turf03 

is this what you want?

average = 'Table'[Column]/CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Sales Group]))

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@ryan_mayu 

 

That will work!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors