Percentile

Hi Saranya3_d .

What I did was the following:

• Added an index column to the data (this is to have only unique values on the ranking)
• Created a calculated column equal to MTTR IN min and formatted as number (if you want to have the MTTR in hours this shuld be that column)
• Created a ranking column

Column Ranking = 
RANKX (
    fILTER ( Sheet1; Sheet1[Priority] = EARLIER ( Sheet1[Priority] ) );
    Sheet1[ID_Sorting] - [Index] / POWER ( 10; 9 );
    ;
    asc;
    DENSE
)

• Created the following measure:

P95 MTTR = 
var Percentile_value = [P95 Count]
Return
CALCULATE (MAX(Sheet1[Overall MTTR in Min]);
  FILTER (
        ALL(Sheet1);
        Sheet1[Column Ranking] = Percentile_value
            && Sheet1[Priority] = MAX ( Sheet1[Priority] )
    )
)

Check PBIX file attach, and tell me if this is the expected result.