cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
travishankins Frequent Visitor
Frequent Visitor

Sum all rows based on column

Morning, 

 

I have a table that contains information such as employee, department, start date, etc.   I have a report that we need to calculate sales based on how many employees are in a department but can't figure out how to sum the number of rows for each department.  

 

I am sure it's something simple and would appreciate some help! 

2 REPLIES 2
Super User
Super User

Re: Sum all rows based on column

What does your data look like? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


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

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Sum all rows based on column

@travishankins,

 

You may try using SUMMARIZE Function to add a calculated table first.

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