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.

Felix,

I followed the same steps but the corresponding overall mttr is showing as one hr, two hrs etc., which is not correct. i have placed the pbix file (PP name) , excel sheet (QA resolved dump) & Manual calculation excel sheet for your reference.

In the pbix, there are two tabs,

1) Own steps - IN percentile - Initially i have created rules and placed over there (without overall mttr)

2) "Followed steps - IN percentile" - Just followed your steps (overall mttr is not coming properly)

Please help me!

https://1drv.ms/u/s!AryZvCsTToGkiFIbyzzbWvqt7Pg9?e=R4j3xv

Thanks,

Saranya

Felix,

I followed the same steps but the corresponding overall mttr is showing as one hr, two hrs etc., which is not correct. i have placed the pbix file (PP name) , excel sheet (QA resolved dump) & Manual calculation excel sheet for your reference.

In the pbix, there are two tabs,

1) Own steps - IN percentile - Initially i have created rules and placed over there (without overall mttr)

2) "Followed steps - IN percentile" - Just followed your steps (overall mttr is not coming properly)

Please help me!

https://1drv.ms/u/s!AryZvCsTToGkiFIbyzzbWvqt7Pg9?e=R4j3xv

Thanks,

Saranya