How to count all duplicate and single values
Hi, I would like to count the number of employee by department, and I use this formula Attrition HC 2 = CALCULATE( COUNTROWS(except(values(Terminate[ID]),VALUES(Zero[Employee ID]))),Reasons_LookUp[Involuntary/Voluntary]="Voluntary") Following is the example of the table Terminate[ID] Employee ID Department Status 12345 Finance Voluntary 12345 Finance Voluntary 23456 Account Voluntary 34567 Human Resources Voluntary 45678 Sales InVoluntary Following is the example of the table Zero[Employee ID] Employee ID Department 99999 Marketing 88888 Marketing However, the result i got is Which it should actually be 2 in finance and the total should be 4. Please help me 🙏 Thank you
