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
  • aishaakhter18's avatar
    aishaakhter18
    Helper I
    2 years ago

    I have not use DAX for it, I am using %GT calculation in X Axis to get percentage, but t giving me incorrect one

    • 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%