Percentile

Hi Saranya3_d ,

You need to create a ranking in order to compare with the percentile value and then use that to find your MTTR.

• Create an ID column on the MTTR table that will be used for your ranking (just add zeros to the rigth in order to have all the hours with the same length:

• Depending on the way you want to do things you may want to do the ranking wiht a measure or with a calculated column result is similar however the measure allows to be more dinamic

Measure  Ranking =
RANKX (
    FILTER (
        ALLSELECTED ( MTTR_Table ),
        MTTR_Table[Priority] = MAX ( MTTR_Table[Priority] )
    ),
    CALCULATE ( MAX ( MTTR_Table[ID] ) ),
    ,
    asc,
    DENSE
)

Column Ranking =
RANKX (
    FILTER ( MTTR_Table, MTTR_Table[Priority] = EARLIER ( MTTR_Table[Priority] ) ),
    MTTR_Table[ID],
    ,
    asc,
    DENSE
)

Now just add the following measure for each Percentile:

P95 MTTR =
CALCULATE (
    MAX ( MTTR_Table[MTTR] ),
    FILTER (
        ALL ( MTTR_Table ),
        [Measure  Ranking] = [P95]
            && MTTR_Table[Priority] = SELECTEDVALUE ( Priority[Priority] )
    )
)

Formula is based on the measure but you can do it based on the column. Also I did not know if you had a Priority for dimension and connecting both of the table but this is not

Check result in attach PBIX.