Scheme Achievement Calculation

[ADSL]

Hi BI Community Team,

we need to pay for employee that achieve the performance based on the scheme that we setup from 90% - 99.99% & 100% up.

Any suggestion/advise

Thanks and Regards,

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RiXRT6EIJFVL9x2af?e=pel4Oy

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

[ADSL]

Hi @Ahmedx,

The measure applied to all types when try to choose/select as the screenshot below. Actually another type doesn't have value yet.

Could we apply the measure for specific type -- A, B, C & D?

Thanks and Regards,

[Ahmedx · Accepted solution]

try this ,

since there are no data about other types yet, I changed your %Ach measure to check if the my measure works
Scheme Calculation.pbix

[ADSL]

Hi @Ahmedx ,

Thank you very much for value feedback and help.

[Ahmedx]

in your Target there was only one type, put the file where there are all types so that I can see what is wrong in the world

[Ahmedx]

Is this what you are looking for?

[ADSL]

Hi @Ahmedx,

Yes, your screenshot is correct. 

May I know the measure to calculate it? 

Thanks and Regards,