How to calculate The Percentile.Inc for unique id

[v-jayw-msft]

Hi @MuthuGOVINDHAN ,

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Anonymous · Accepted solution]

FILTER('Monthly review - DRI leevl','Monthly review - DRI leevl'[DR_Closed] )

Doesn't look like a condition to me.  You need something like

'Monthly review - DRI leevl'[DR_Closed]  = (condition x)

Also, you really don't need the filter part, you can just write

DR_90%_Fill_Rate = CALCULATE(PERCENTILE.INC('Monthly review - DRI leevl'[TAT_GLB],0.9), ,'Monthly review - DRI leevl'[DR_Closed] = (condition x ) )