SLA Calculation

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.