Forum Discussion

aishaakhter18's avatar
aishaakhter18
Helper I
2 years ago

Percentage Calculation in Power BI

I need to calculate the percentage based on the number of programs with a "Yes" response and how many are planned or have a "No" response. However, the challenge is that each program consists of mult...
Need Help
ronrsnfld's avatar
ronrsnfld
Super User
2 years ago

What would you consider the correct result? How are you handling the "Under Assessment" option? I get very different results for "Yes"

aishaakhter18's avatar
aishaakhter18
Helper I
2 years ago
  1. Service Order Status Response = Yes: This counts as a "Yes" for a program.
  2. Service Order Status Response = Planned: This only considers unique program numbers without other responses.
  3. Service Order Status Response = No: This also only considers unique program numbers without other responses.
  4. Service Order Status Response = Under Assesment: This also only considers unique program numbers without other responses.

 The total percentage for all respnses should ne equal to 100%

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    2 years ago

    You are only restating part of your original post and not providing any percentages. 

     

    How does that indicate your expected results? I thought the expected results would be a percentage for each status. But you don't show how they are derived.

     

    What if a program has, for example, status responses of "No", "Planned" and "Under Assessment" for the different Service Order #'s?

     

    You really need to be more specific. I cannot figure out, for example, how you derive 81% as the correct answer for "Yes".

     

    How do calculate 81% "Yes"

    What result would you expect for each of the Planned / Under Assessment / No categories.

     

    The closest I can come, trying to use your written description, is:

     

     

    • aishaakhter18's avatar
      aishaakhter18
      Helper I
      2 years ago

      In my real data, i have total # number of programs = 45

      1. Out of 45  Programs , 37 Service Order Status Response = Yes: 
      2. Out of 45  Programs , 16 Service Order Status Response = Under Assesment 
      3. Out of 45  Programs , 3 Service Order Status Response = Planned 

      And if you take a percentahe then you will get the Chart I shared with you, In some senarios I have no so need to keep one sanario for it too 

       

      • aishaakhter18's avatar
        aishaakhter18
        Helper I
        2 years ago

        Also I have total # of programs are 45 , and if Yes are 37 then left over that should 45-37= *, Only 8 program should be in Planned or under assesmet status, and that what I am trying to figure our how to calculate thos correctly that the prog that are already have yes ststus should not be count again for other status