Need Help - repeat contact formula

[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-juanli-msft · Accepted solution]

Hi @demonfc

Create a calculated column

Column =
CALCULATE (
    COUNT ( Table1[Customer Name] ),
    FILTER (
        ALLEXCEPT ( Table1, Table1[Employee Name] ),
        [Customer Name] = EARLIER ( Table1[Customer Name] )
    )
)

Best Regards

Maggie