Forum Discussion
Dynamic Incentive Payout Curve?
I have 6 buckets of achievment percentages:
The targets in the buckets are hard coded. I need the math to determine what the % Incentive would be for datapoints between the buckets. 75% is an example. If at 70% they receive 50% incentive, and at 80% they receive 60% incentive, how to I determine what % Incentive would be calculated if they were at 75%, or better yet another calculation between 70-80% like 72.6%? There should be a logical mathematical curve that can be applied and I'm trying to determine what that would be between the buckets. Any ideas?
| Buckets | Target Achieved | % Incentive |
| 1 | 70% | 50% |
| ? | 75% | ? |
| 2 | 80% | 60% |
| 3 | 100% | 100% |
| 4 | 110% | 150% |
| 5 | 120% | 180% |
| 6 | 160% | 220% |
5 Replies
lg1551 , Not very clear, but if you need a bucket on measure and then want to use value, use dynamic segmentation
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-kSorry that it wasn't very clearly worded. I think I was able to achieve it with a variable DAX measure. Still testing my results.
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.
