How to count values in Matrix table?

[Anonymous]

Hi

I have a data as below

Employee Name	Business Unit
Jack	ABC
Jill	CCD
Sam	ABC
Andy	DED
Mark	CCD
Jim	DED
Jerry	ABC

I am trying to create a matrix table and need below output

Business Unit	Total Employee
ABC	3
CCD	2
DED	2

I dragged Business Unit into rows in the matrix table and dragged employee name into values and changed to count. However, the values are not matching exactly.

Can you please advise?

[Anonymous]

@Ashish_Mathur  It's working now. Thanks

[Ashish_Mathur · Accepted solution]

Hi,

Drag Business unit to the table viz and write this measure

Measure = counta(Data[Employee Name])

Hope this helps.

[Anonymous]

@Ashish_Mathur Thanks for your quick reply. I created the above measures. I dragged the business Unit into a row and measure it into a value in the matrix table. However, the values are not matching. 

I think I am doing it in a wrong way. Please let me know

[Ashish_Mathur]

Share the download link of your PBI file.