Calculate Score Targets per Agent

Question

Hello everyone,&nbsp;Thanks in advance for your help.&nbsp;I'm currently working on a dashboard where Agents in a call center are being evaluated per call. The score goes from 0 to 100. (90% is the target)&nbsp;I have a table similar like the following&nbsp;ID -&nbsp; &nbsp; &nbsp; Date -&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Agent -&nbsp; &nbsp; &nbsp; &nbsp;... - Score&nbsp; &nbsp; &nbsp; Status1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2019&nbsp; &nbsp; &nbsp; &nbsp; Louis&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 93&nbsp; &nbsp; &nbsp; &nbsp; On Goal2&nbsp; &nbsp; &nbsp; &nbsp;1/1/2019&nbsp; &nbsp; &nbsp; &nbsp; Ana&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 87&nbsp; &nbsp; &nbsp; &nbsp; Not on Goal3&nbsp; &nbsp; &nbsp; &nbsp;1/2/2019&nbsp; &nbsp; &nbsp; &nbsp; Mike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 91&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;On Goal4&nbsp; &nbsp; &nbsp; &nbsp;1/9/2019&nbsp; &nbsp; &nbsp; &nbsp; Louis&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 88&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Not on Goal5&nbsp; &nbsp; &nbsp; &nbsp;1/8/2019&nbsp; &nbsp; &nbsp; &nbsp; Ana&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 94&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;On Goal6&nbsp; &nbsp; &nbsp; &nbsp;1/9/2019&nbsp; &nbsp; &nbsp; &nbsp; Mike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 99&nbsp; &nbsp; &nbsp; &nbsp; On Goal&nbsp;And so on...&nbsp;How could I create a measure that shows me how many people I had on goal on a specific week?&nbsp;&nbsp;Lets say I have 50 employees as a total, how many of them are on goal for week 13? For example.&nbsp;&nbsp;Thank you&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

hotchilli · Answer

You'll need a Date table so that you can define the Week Number.

Add a relationship between Date table and the Agents table.

Put Week Number in a slicer.

Drag Status on to a table visualisation twice.

Put one Status as 'Do not summarize'.

Put the other as 'Count'

anonymous · Answer

I already have the data model, DateTable, EvaluationsTable, AgentsTable...

I just did what you told me and gave and It counts every evaluation we have done so far, and how many of them are on goal or not.

The thing is, per week every agent has around 4-6 evaluations, So i need to know the average of the score, and if that average is on goal or not, in the same way on how many evaluations the agent was not on goal as well.

I would like to have like an indicator that shows the percentage of people on goal globally, per week, and so on..

Idk if I make sense

v-frfei-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Have a try :)
&nbsp;
Measure 2 =
CALCULATE (
    COUNT ( facttable[Agent] ),
    FILTER (
        facttable,
        WEEKNUM ( 'facttable'[Date] ) = 13
            &amp;&amp; facttable[score] &gt;= 90
    )
)

anonymous · Answer

Hi,&nbsp;&nbsp;The thing is in a week, every agent has more than 1 evaluation, so that measure will count every evaluation of the same person that is on goal, I need to use the AverageScore per week to determine if an agent is on goal or not for any week throughout the year.&nbsp;&nbsp;&nbsp;

anonymous · Answer

Your best bet would be row context. It will evaluate each as a unique value. I dont have a clear idea, but I would try an IF measure (condition being grades > 90%). Try using the following logic:
https://community.powerbi.com/t5/Desktop/IF-statement-in-Measure-need-help/td-p/135388

Forum Discussion

Calculate Score Targets per Agent

6 Replies

Related content

Calculating Score Difference between oldest and newest score

Calculating Days late with specific target times

Daily Sales Target Calculation

CALCULATE INDEX SCORE

Z-Score calculation error / data type mismatch