Forum Discussion

demonfc's avatar
demonfc
Microsoft Employee
8 years ago
Solved

Need Help - repeat contact formula

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 NameCustomer Namecount of assistance
EmpAAbel4
EmpBJohn5
EmpCDerek1
EmpDAbel1
EmpBJohn5
EmpFJohn2
EmpBJohn5
EmpHDoug1
EmpIChris1
EmpEChris2
EmpGChris1
EmpEChris2
EmpGJohn1
EmpCChris1
EmpBAbel1
EmpHDerek1
EmpAAbel4
EmpBJohn5
EmpAAbel4
EmpFJohn2
EmpBJohn5
EmpAAbel4

 

Any and all help is greatly appreciated. 

Thank You

  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    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

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    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