cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

## Calculation to determine SLA, inscident

I have to create a SLA measure for % INC resolved same day

For the formula to be valid

Opened date and resolved date have to be equal

Formula used in ServiceNow is:

% INC resolved same day: ([[Number of incidents resolved on the same day opened / 30d running AVG]]/[[Number of resolved incidents / 30d running AVG]])*100

Number of incidents resolved on the same day opened = opened date is equal to the resolved date

Total Number of resolved incidents

 Incident number Opened Date Opened Time Resolved Date Resolved Time Inc01 01/12/2020 00:32:14 01/12/2020 02:59:18 Inc02 01/12/2020 08:31:32 01/12/2020 08:40:39 Inc03 01/12/2020 23:41:23 30/12/2020 23:43:48 Inc04 02/12/2020 03:46:39 03/01/2020 03:49:24 Inc05 02/12/2020 22:58:01 05/01/2020 23:00:56

1 ACCEPTED SOLUTION
Super User

@seunao , Try to join both dates Open date and resolved date with a date column of date table. Make sure the Open date is active join. and other one is inactive and activated in a measure using userelationship

resolved on same date

calculate(count(Table[Incident number]), filter(Table , Table[Opened Date] = Table[Resolved Date] ))

Super User

@seunao , Try to join both dates Open date and resolved date with a date column of date table. Make sure the Open date is active join. and other one is inactive and activated in a measure using userelationship

resolved on same date

calculate(count(Table[Incident number]), filter(Table , Table[Opened Date] = Table[Resolved Date] ))

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors