Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Paginated report percentile calculation

Hi All,

 

Does anyone have any upto guidance on how complete percentile calcualtion in paginated reports?

I need to calculate 95th and 99th Percentile to meet a requirement to replicate a current excel based report.

 

I've tred to follow old articles for SSRS but unable to find one that works for me.

 

Thanks in advance for any help

 

Need Help

2 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous,

     

    There are no functions provided in power bi paginated report for direct function. You can use a formula similar to the one below to get the value you need.

    =(max(Fields!values.Value) -min(Fields!values.Value))*0.95+min(Fields!values.Value)

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for reply, unfortunatley the results don't match the measure I have in PowerBi Desktop

       

      Here is what I have in PowerBi Desktop

      Percentile95 = PERCENTILE.INC(my_table[MeasureValue],0.95)
       
      Any other ideas?
       
      Thanks