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:

TargetTarget PointQuarter 1 ValueQuarter 2 ValueQuarter 3 ValueQuarter 4 Value
Target no1...1    
Target no2...1    
Target no3...2    

So my emolpyee has a target point for each quareter where if he reaches a certain percentage he gets a point or he gets a zero. at the end of each quarter if he reaches a 14 or more points, he gets commision.

 

I have an ID for each employee, a Date table, and a sales table. But what is the best way to add the table to my model?

 

Do I create a table that looks like this, or is there a better way of solving this:

TargetTarget PointQuarterValue
Target no1...1Q1(calculated column)
Target no1...1Q2.. 
Target no2...1Q1 
Target no2...1Q2.. 
Need Help

2 Replies

  • 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