topic Re: Getting count per category in one column using data in another column in DAX Commands and Tips

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

kk_shp_user — Mon, 08 Apr 2024 11:33:19 GMT

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.

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

tamerj1 — Sun, 07 Apr 2024 20:52:55 GMT

Hi kk_shp_user

Try using TREATAS

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

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

kk_shp_user — Mon, 08 Apr 2024 11:30:30 GMT

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

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

tamerj1 — Mon, 08 Apr 2024 12:19:57 GMT

kk_shp_user

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

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

kk_shp_user — Mon, 08 Apr 2024 13:06:42 GMT

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.