Forum Discussion
Solved
Order count - Benchmark against Employee count
Hello everyone, First post here on the forum, relatively new to PowerBi, getting out of the basics and navigation and now struggling with some more 'complex' calculations where I cannot seem to find...
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.
oh wow, such great and quick responses, thank you all!
I will check the answers and provide feedback throughout the day/tomorrow!