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 ...
Need Help
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