Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
3 years ago
Solved

Scheme Achievement Calculation

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,
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    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

Ahmedx's avatar
Ahmedx
Super User
3 years ago

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's avatar
    ADSL
    Post Prodigy
    3 years ago

    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's avatar
      Ahmedx
      Super User
      3 years ago

      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's avatar
        ADSL
        Post Prodigy
        3 years ago

        Hi Ahmedx ,

        Thank you very much for value feedback and help.

    • Ahmedx's avatar
      Ahmedx
      Super User
      3 years ago

      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