Forum Discussion

taspland's avatar
taspland
Frequent Visitor
5 years ago
Solved

SLA Calculation

Hi, i'm trying to get a correct SLA state however i'm unable to get the data to show correctly. and have no idea how to split the incident and task sla on  I have a table with Ticket ID, Ticket Typ...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, taspland 

    I’ve downloaded your pbix file and I can roughly understand your requirement according to your description, you can try this calculated column:

    SLA STATE =

VAR _incidentsla=RELATED(SLA[incident sla])

VAR _tasksla=RELATED(SLA[Task SLA])

Return

IF(

    [ticket type]="Incident",

    IF(

        [business_duration]>=_incidentsla,

        "SLA Violated","SLA OK"),

        IF(

        [business_duration]>=_tasksla,

        "SLA Violated","SLA OK")

)

    The output is like this:

     

    And you can get what you want.

    You can download my test pbix file below

     

    If you still have a problem, you can explain your expected result in detail with examples.

    How to Get Your Question Answered Quickly 

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

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

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, taspland 

I can’t download the sample file from your google link and it says that I need access:

 

But according to your DAX formula, I can roughly understand your requirement, you can try to change the formula of the calculated column like this:

SLA STATE=

VAR _sla=Calculate(MAX(SLA[inc sla]),Filter(All(SLA),[P]=Earlier(task[priority])))

Return

IF(

      Task[business_duration]>=_sla,

      “SLA Violated”,

      “SLA OK”)

 

If this result is not what you want, you can give me the access to your google link and your explain your expected result with examples in detail.

How to Get Your Question Answered Quickly 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

taspland's avatar
taspland
Frequent Visitor
5 years ago

Hi v-robertq-msft thankyou for your assistance, i have provided you with access. i'm getting results that doesn't make sense, if you look below you can see it's showing SLA breached for time less than SLA Met, i think it maybe something with Incident vs tasks?  these below were incidents