Forum Discussion

paulfink's avatar
paulfink
Post Patron
6 years ago

Power Bi DAX: Complex Commission Plan

Hi guys,   got a bit of a challenge.   So I have been given a sales commission plan for one of the managers and it is quite complex so I am not sure how I'm doing to do this so please give me a h...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

paulfink ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • paulfink's avatar
    paulfink
    Post Patron
    6 years ago

    added a dummy table in my post. Hope this helps

    • dax's avatar
      dax
      Community Support
      6 years ago

      Hi paulfink ， 

      If possible, could you please explain the logic of 5% result to me? And there the last 3 row are the fixed value? By the way, did you mean above image is your expected output? If possible, could you please inform me your data structure?

      Best Regards,
      Zoe Zhi

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

      • paulfink's avatar
        paulfink
        Post Patron
        6 years ago

        Hi dax 

         

        The 5% of the team order value is that if the team hit their target, then the manager receives a 5% of that sales total.

         

        if the team target is 5000 and they make 6000 then the manager receives 30.

         

        I have another table in my PBi report with all the targets and sales.

         

        The table i posted is the commission plan i received. Amounts changed for privacy reasons.

         

        Is that easier?