I have a requirement to view the employee count by manager (employee ID) and also view it by Country only. As you can see, there are 12 managers who are correctly showing the emp_count, and another measure showing if they are managing employees more than 10 (3 managers).
When I want to see the value by just the Country (where the manager is), I expect that the count for the USA will be 3 managers, however I am only seeing 1 which I believe something is wrong in my formula.
Could you help me fix the problem?
Iif([Date of Hire Adjusted: # Distinct IA_personHashKey] > 10,1 ,0 )
