Forum Discussion
Solved
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...
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 🙂
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 🙂