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 dataset.

 

thankyou, Rob

 

 

 

 

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)

8 Replies

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

  • MattiaFratello's avatar
    MattiaFratello
    Super User
    1 year ago

    Hi rpjheeney ,

     

    First create a DAX Measure that calculates the count of SLA Achieved
    COUNT OF SLA = CALCULATE(COUNT(SLA_ACHIVED), SLA_ACHIEVED = SLA_ACHIEVED)

     

    then create another DAX Measure as follow:

    DIVIDE(COUNT OF SLA, COUNT(SLA_ACHIEVED))

     

    Format this one as %

    • rpjheeney's avatar
      rpjheeney
      Frequent Visitor
      1 year ago

      Hi, thankyou for the response. 

      I'm looking to capture the percentage total where the value "SLA Achieved" appears across the table.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, rpjheeney 

    Glad to hear you solved the problem!  
    If you can, please mark the correct answer as a standard answer, which will be beneficial for future users to read this post. 

     

    Best Regards

    Yongkang Hua