Calculate % of tickets resolved on time

[Beres]

Hello,

I am new to Dax and trying to figure out how to:

1. Count the values of column 2 in Table 2 (true or false column)
2. Compare columns 1 from Tables 1 & 2 (incident key reference)
3. Provided column 3 in Table 1 meets certain criteria (resolved or closed)
4. Based on criteria in column 3 of Table 2. (type of SLA, contains the word resolution)
5. And column 4 of Table 2 is not set to pause or cancelled 

Table 1 is Incident  

Table 2 is SLA 

I need to compare the incident number and task number from both tables, if they are equal & the state column in the incident table is set to resolved or closed.

I need to then count the has breached column in the SLA table,  if the value is false, provided the SLA definition has the word resolution in it, and the stage column in the SLA table is not set to pause or cancelled. 

The closed resolution SLA is either

Desk P1 resolution

Desk P2 resolution

Desk P3 resolution
Desk P4 resolution

I am trying to count how many have breached or not breached.

Thanks for helping with this.
The below links are to a sample excel file and pbix file

https://www.dropbox.com/scl/fi/xw1026g0gfyw9y3zc6mj6/incident.xlsx?dl=0&rlkey=ztc7q0lekh4c5nzyklwzch...

https://www.dropbox.com/s/ix4rog3gdplt9ad/sampledata.pbix?dl=0

[lbendlin]

Thank you for providing the sample data.  For the first task you can count the rows of any column.  Here I used the Task column but that is totally arbitrary.  Make sure not to select "Count (Distinct)".

For the next steps you may want to reformulate the question. "compare" how?