Forum Discussion
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 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
try with
Column = CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Employee Name], Table1[Customer Name] ) )
2 Replies
try with
Column = CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Employee Name], Table1[Customer Name] ) )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
