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

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

#### Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

#### 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.

#### Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

#### Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors