Calculation to determine SLA, inscident

[seunao]

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

thanks for your help in advance. 

[amitchandak · Accepted solution]

@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] ))

For other and steps refer https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...