Paginated report percentile calculation

[Anonymous]

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

[v-chenwuz-msft]

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]

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