Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I'm trying to put in a formula that will show me the accuracy score for each representative for a specific month like all of July. I already have the measure that shows me the overall accuracy but need an additional measure or column that I can plug in for each month to show performance. My current Accuracy measure for overall accuracy is:
Accuracy = Sum('PC'[Count Correct])/COUNT('PC'[Total Jobs]) both calculated columns.
I have also created a Month number calculated column.
I'm ok with having to add a measure or column for each month if its easier.
Thank you for your assistance.
Solved! Go to Solution.
Hi @wjenkins3811,
I'm not very clear about your requirement.
If it is convenient, could you share some data sample and your expected output?
For reference, you could have a look at this similar thread.
Best Regards,
Cherry
Hi @wjenkins3811,
I'm not very clear about your requirement.
If it is convenient, could you share some data sample and your expected output?
For reference, you could have a look at this similar thread.
Best Regards,
Cherry
User | Count |
---|---|
117 | |
74 | |
62 | |
50 | |
45 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |