Getting count per category in one column using data in another column

[kk_shp_user]

Edit: Simplified my example and description to make it easier to understand.

I have a data like below. The table contains employees and managers. Managers are also present as employee records.

I want to calculate the no. of emps per manager title. I am trying to populate the below table visual and am having a challenge in getting the highlighted value.

[tamerj1 · Accepted solution]

Hi @kk_shp_user 

Try using TREATAS 

Total_Emps_at_Title =
CALCULATE (
COUNTROWS ( 'Table' ),
TREATAS ( VALUES ( 'Table'[recruiter_title] ), 'Table'[emp_title] )
)

[kk_shp_user]

Thanks for yourt reply but the solution did not get the expected result.

[tamerj1]

@kk_shp_user 

Would be helpful if you present the results that you got. 

[kk_shp_user]

Apologies, its sensistive data hence posted an exmaple.

That said, than you so much. I got it to work using TREATAS() like you mentioned. I was using a measure inside the calculate and so had to add the ALLEXCEPT condition to remove ther filters affecting the measure and the TREATAS worked as expected.