how can i do count on group by?

[ppgandhi11]

Hi,

I am a newbie in Power BI. How would i create a measure to do count on group by?

The equivalent SQL would be:

select department, count(department) from customers where location = 'US' group by deparment

department   count(department)

sales                 25

HR                    28

finance             30

:

:

Thanks.

[ppgandhi11 · Accepted solution]

I figured it out without creating the measure formula. In Pie chart I could get both the data points and it automatically shows the total by grouping. Thanks!