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 Community Highlights

Check out a full recap of the month!

#### August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

#### Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors