Sum all rows based on column

[Anonymous]

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! 

[v-chuncz-msft]

@Anonymous,

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

[Greg_Deckler]

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