Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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,
Solved! Go to 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
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.
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,
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
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
Is this what you are looking for?
Hi @Ahmedx,
Yes, your screenshot is correct.
May I know the measure to calculate it?
Thanks and Regards,
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
102 | |
94 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |