Forum Discussion

SergioHB's avatar
SergioHB
Helper I
6 years ago
Solved

SLA Achivement Calculation

Hi guys,

 

I'm starting with PowerBI and DAX and would like if some could give me a hand on the following. I'm creating a dashboard to follow-up SLA achivement depending on priorities but I don't know how can I determinate dinamically when a case has hit the first reponse or the resolution SLAs.

 

Following a table with some data to explain. The achivement columns should have a null or 1 depending if the case has achieved the SLA timings according to the nexts tables.

 

This small table that should be counting cases by priority and also counting how many of them have achieved the SLA with a % of the total.

 

The same calculation for Responsiveness (First response)

 

 

Any help on this would be very welcome.

Thanks

 

 

Need Help
Show and Tell
Tips and Tricks
  • Icey's avatar
    Icey
    6 years ago

    Hi SergioHB ,

    Is this what you want? This is my PBIX file.

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi SergioHB ,

    Is this what you want? This is my PBIX file.

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • SergioHB's avatar
      SergioHB
      Helper I
      6 years ago

      Hi Icey 

      Thanks so much for helping on this. Apparently it's working as I expected but just a couple of measures are not calculating on my side. They are:

      • Achieved Resolution
      • Achieved Response

      with the following message: "A single value for column 'ClosedDate' in table 'Case' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.."

       

      Any idea?

      • Icey's avatar
        Icey
        Community Support
        6 years ago

        Hi SergioHB ,

        You can create the two measures like so:

        Achieved Response Measure =
IF ( ISBLANK ( MAX ( 'Table'[Initial_Response] ) ), BLANK (), 1 )
        Achieved Resolution Measure =
IF ( ISBLANK ( MAX ( 'Table'[ClosedDate] ) ), BLANK (), 1 )

        In the pbix file I shared before, these two are columns.

         

        Best Regards,

        Icey

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.