Forum Discussion

Halah_MS's avatar
Halah_MS
Frequent Visitor
3 years ago

Specific Target for an employee

I have a target table for all of my employees and it is working well. However, I have one employee whose target is completely different and I am not sure how to formulate it. The table is: Target...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Halah_MS ,

You can insert each target for every employee. Then you can create a column.

column =
VAR _1 =
    CALCULATE (
        SUM ( table[points] ),
        FILTER ( ALL ( table ), table[person id] = Earlier ( table[person id] ) )
    )
RETURN
    IF ( _1 >= table[target], "YES", BLANK () )

If I have misunderstood your meaning, Please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Halah_MS's avatar
Halah_MS
Frequent Visitor
3 years ago

Hello,

 

I will provide an example, I have an employee named Max who has complicated targets to reach each Quarter. These are three examples of his targets:

 

1- If Sales % is above 90% for Region 1 he gets 1 point

2- If GP % is above 90% for Region 2 he gets 1 point

3- If Category 1 Sales is above 100k$ he gets 2 points

4- ...

and so on. Keeping in mind that these targets are for each quarter. If the total of his points is more than 14 he gets a commission.

 

so my question is what is the best way to add this into my power bi data? I want to be able to view Max targets and how many points he got

 

this is one i was thinking of doing it, is it efficient:

or is it going to be redundant? since i will repeat each target for each quarter ( target repeated 4 times)

 

hope this makes more sense