cancel
Showing results for
Did you mean:
Helper V

## Top 10%

I know how to use the Top N filter, but the ask is for the top 10% of values. We have a large dataset of tickets, each ticket has a "duration" value. We want to see the 10% of those values in a table

Any help on how to filter that is appreciated

1 ACCEPTED SOLUTION
Super User IV

@bhmiller89

Top 10% of the tickets and their duration.

``````Top 10% Duration =

VAR T10 =
TOPN(
ROUNDUP(
COUNTROWS(ALL('Table'))*0.1,0),
ALL('Table'),
[Total Duration],
DESC
)
RETURN
CALCULATE(
[Total Duration],
KEEPFILTERS(T10)
)``````

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

Proud to be a Super User!

4 REPLIES 4
Super User IV

@bhmiller89

Top 10% of the tickets and their duration.

``````Top 10% Duration =

VAR T10 =
TOPN(
ROUNDUP(
COUNTROWS(ALL('Table'))*0.1,0),
ALL('Table'),
[Total Duration],
DESC
)
RETURN
CALCULATE(
[Total Duration],
KEEPFILTERS(T10)
)``````

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

Proud to be a Super User!

Super User II

You could try something like this:

``````Top 10% Customer =
VAR Num =
INT ( COUNTROWS ( Customer ) * 0.1 )
VAR Top10Customer =
TOPN ( Num, Customer, [Total Sales], ASC )
RETURN
Top10Customer``````

Thank you,
Antriksh Sharma
Super User IV

@bhmiller89 , refer

or

Proud to be a Super User!

Super User III
You could create a measure to calculate the percent of values and filter for within top 10%?

______________

Check out my Data Stories Gallery Christmas Report: Are you on Santa's Naughty or Nice List?

______________

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.

www.excelwithallison.com

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!