Forum Discussion

Saranya3_d's avatar
Saranya3_d
Helper I
6 years ago

Percentile

<top>  Hi Experts, I’m looking for percentile calculation in powerbi report. The In-build formula is not working out for my requirement, so I have written an query to fetch the outcome as per the ...
Saranya3_d's avatar
Saranya3_d
Helper I
6 years ago

Hi MFlexi,

 

Thanks a ton for your response!

 

I did the same in my pbix file but MTTR is showing as blank. i have attached the screenshot of the pbix file (no measure or columns in the data) for your reference. I tried to attach here but couldn't see the attachment icon. 

 

Request you to help me to arrive the percentile please. It would be great help :)!!

 

Waiting for your reply! Thanks in Advance!

 

Thanks,

saranya 

Saranya3_d's avatar
Saranya3_d
Helper I
6 years ago

screenshot of pbix

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Hi Saranya3_d ,

     

    You can you share a file trough onedrive, googledrive, wetransfer or similar links.

     

    Are you abble to share a file?

    • Saranya3_d's avatar
      Saranya3_d
      Helper I
      6 years ago

      Mflexi,

       

      Pbix file has been placed in the below drive. Please help me to arrive the precentile. 

       

      https://1drv.ms/u/s!AryZvCsTToGkiFbVLcHPg7eaneEr

       

      PS:  I will write a query in column to change the "Overall MTTR in Hours" into "HH:MM:SS" format. All the data's are available in the single table like Priority, Ticket ID (unique filed), Ovearll MTTR in hours, overall mttr in min, created and resolved time. 

       

      Thanks,

      Saranya

      • MFelix's avatar
        MFelix
        Super User
        6 years ago

        Is it possible to share the excel file?

         

        I need to make some changes in order not having duplicated rankings.