Formula help

[demonfc]

In need of help writing a formula where I can get a number of the customers my employees have helped. The formula would output the number of times an employee helped the same customer if they helped the same customer numerous times. The column would look like column 3. 

Employee Name	Customer Name	count of assistance
EmpA	Abel	4
EmpB	John	5
EmpC	Derek	1
EmpD	Abel	1
EmpB	John	5
EmpF	John	2
EmpB	John	5
EmpH	Doug	1
EmpI	Chris	1
EmpE	Chris	2
EmpG	Chris	1
EmpE	Chris	2
EmpG	John	1
EmpC	Chris	1
EmpB	Abel	1
EmpH	Derek	1
EmpA	Abel	4
EmpB	John	5
EmpA	Abel	4
EmpF	John	2
EmpB	John	5
EmpA	Abel	4

Any and all help is greatly appreciated. 

Thank You

[v-piga-msft]

Hi @demonfc,

The solution of Zubair_Muhammad could solve your problem.

If you have solved the probelm, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[Zubair_Muhammad · Accepted solution]

@demonfc

try with

Column =
CALCULATE (
    COUNTROWS ( Table1 ),
    ALLEXCEPT ( Table1, Table1[Employee Name], Table1[Customer Name] )
)