Forum Discussion
Order count - Benchmark against Employee count
Hi DriesD
With relationships and measure below, we could get the result easily.
total = DISTINCTCOUNT(Table1[Ordernumber]) average = [total]/SUM(Table2[Technicians])But for the next question, total per day/ technicians, i don't know what technicians should be used.
Could you give me an example?
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi DriesD
With relationships and measure below, we could get the result easily.
total = DISTINCTCOUNT(Table1[Ordernumber])
average = [total]/SUM(Table2[Technicians])
But for the next question, total per day/ technicians, i don't know what technicians should be used.
Could you give me an example?
Maggie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi Maggie, it's basically the same.
I'm trying to look at all orders created per company code, which you have shown in your example. Per day is the same thing, the total amount of orders created per day, per technician
(so total order count created on that day, divided by total amount of technicians)
thanks for your reply, I will look into this and revert back!
Hi DriesD
As i checked, my reply covers the above you concern.
If there is still any problem, please tell me.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.