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] )
)
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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