Forum Discussion
Solved
Getting count per category in one column using data in another column
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. ...
Hi kk_shp_user
Try using TREATAS
Total_Emps_at_Title =
CALCULATE (
COUNTROWS ( 'Table' ),
TREATAS ( VALUES ( 'Table'[recruiter_title] ), 'Table'[emp_title] )
)
Would be helpful if you present the results that you got.
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.