Forum Discussion

demonfc's avatar
demonfc
Microsoft Employee
7 years ago
Solved

Formula help

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 ...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    demonfc

     

    try with

     

    Column =
CALCULATE (
    COUNTROWS ( Table1 ),
    ALLEXCEPT ( Table1, Table1[Employee Name], Table1[Customer Name] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

demonfc

 

try with

 

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