how can i do count on group by?

Question

Hi,&nbsp;I am a newbie in Power BI. How would i create a measure to do count on group by?&nbsp;The equivalent SQL would be:&nbsp;select department, count(department) from customers where location = 'US' group by deparment&nbsp;department&nbsp;&nbsp; count(department)sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25HR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28finance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30::&nbsp;&nbsp;Thanks.&nbsp;&nbsp;

ppgandhi11 · Accepted Answer

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

Forum Discussion

how can i do count on group by?

1 Reply

Related content

Count of groups of distinct count by group

Fabric & Azure Data User Group Program Requirements & Benefits

Community User Group Experience

Counting nulls

DISTINCT COUNT AND GROUP BY