cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## How to calculate The Percentile.Inc for unique id

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I

## Re: How to calculate The Percentile.Inc for unique complaint Id's

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 ) )

2 REPLIES 2
Highlighted
Resolver I

## Re: How to calculate The Percentile.Inc for unique complaint Id's

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 ) )

Highlighted
Community Support

## Re: How to calculate The Percentile.Inc for unique id

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.