Dynamic Incentive Payout Curve?

[lg1551]

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%

[Ashish_Mathur]

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%)?

[lg1551]

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.

[lg1551]

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.

[amitchandak]

@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/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

[lg1551]

Sorry that it wasn't very clearly worded. I think I was able to achieve it with a variable DAX measure. Still testing my results.