topic Re: Dynamic Incentive Payout Curve? in Desktop

Dynamic Incentive Payout Curve?

lg1551 — Fri, 31 Mar 2023 20:16:14 GMT

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%

Re: Dynamic Incentive Payout Curve?

amitchandak — Sat, 01 Apr 2023 02:29:00 GMT

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-k

Re: Dynamic Incentive Payout Curve?

Ashish_Mathur — Sat, 01 Apr 2023 02:36:49 GMT

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

Re: Dynamic Incentive Payout Curve?

lg1551 — Mon, 03 Apr 2023 13:32:39 GMT

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.

Re: Dynamic Incentive Payout Curve?

lg1551 — Mon, 03 Apr 2023 13:32:42 GMT

Re: Dynamic Incentive Payout Curve?

lg1551 — Mon, 03 Apr 2023 13:33:53 GMT

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.