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.