Forum Discussion
Dynamic Incentive Payout Curve?
Hi,
I am not sure of how much i can help but i would like to try. Share another table which i presume will have employee codes and Actual achievement (%). If possible, also show the expected result for a few sample employees. Also, what Incentive would you expect if the actual achievement is 45% (or any % below 70%)?
I think I have my answer here. I created a DAX formula with variables for each bucket and additional variables that determines the % difference between the actual achievement (a measure) and each bucket. It applies that percentage difference to the incentive variables. So, regardless of the achievement percentage (where it falls between buckets), I get the correct increment of incentive. Still validating with the available data but so far it appears to be working correctly with a test table I created. I will circle back if I run into issues.
I think I have my answer here. I created a DAX formula with variables for each bucket and additional variables that determines the % difference between the actual achievement (a measure) and each bucket. It applies that percentage difference to the incentive variables. So, regardless of the achievement percentage (where it falls between buckets), I get the correct increment of incentive. Still validating with the available data but so far it appears to be working correctly with a test table I created. I will circle back if I run into issues.
