Forum Discussion

rpjheeney's avatar
rpjheeney
Frequent Visitor
1 year ago
Solved

Percentage Help

Hi all Im trying to display the value highlighted below as a percentage, however when i attempt to convert it, it shows 100%. I'm looking to display the percentage for SLA Achieved across the dat...
Need Help
Tips and Tricks
Tutorial Requests
  • MattiaFratello's avatar
    MattiaFratello
    1 year ago

    You are missing a part of the CALCULATE, 

     

    Use the formula provided by rajendraongole1 

     

    If this helped you, please feel free to send a thumb up 

     

    SLA Achieved Percentage =
    VAR TotalCount = COUNT('Table'[SLA Status]) -- Count of all SLA statuses
    VAR AchievedCount = CALCULATE(COUNT('Table'[SLA Status]), 'Table'[SLA Status] = "SLA Achieved") -- Count of only "SLA Achieved"
    RETURN
    DIVIDE(AchievedCount, TotalCount, 0)

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi rpjheeney  - It looks like your measure for "SLA Achieved" is currently displaying as a count. When you try to convert it to a percentage, it likely calculates the percentage as 1.00 (or 100%) because it's not being divided by the total count of all SLA statuses.

 

SLA Achieved Percentage =
VAR TotalCount = COUNT('Table'[SLA Status]) -- Count of all SLA statuses
VAR AchievedCount = CALCULATE(COUNT('Table'[SLA Status]), 'Table'[SLA Status] = "SLA Achieved") -- Count of only "SLA Achieved"
RETURN
DIVIDE(AchievedCount, TotalCount, 0)

  • rpjheeney's avatar
    rpjheeney
    Frequent Visitor
    1 year ago

    Thankyou for this, i've attempted to run this and it hasnt worked.

     

    Please can you advise? Thanks, Rob

     

     

    • MattiaFratello's avatar
      MattiaFratello
      Super User
      1 year ago

      You are missing a part of the CALCULATE, 

       

      Use the formula provided by rajendraongole1 

       

      If this helped you, please feel free to send a thumb up 

       

      SLA Achieved Percentage =
      VAR TotalCount = COUNT('Table'[SLA Status]) -- Count of all SLA statuses
      VAR AchievedCount = CALCULATE(COUNT('Table'[SLA Status]), 'Table'[SLA Status] = "SLA Achieved") -- Count of only "SLA Achieved"
      RETURN
      DIVIDE(AchievedCount, TotalCount, 0)

      • rpjheeney's avatar
        rpjheeney
        Frequent Visitor
        1 year ago

        this has now worked. Thankyou everyone for your feedback, greatly appreciated!