Forum Discussion
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
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 🙂
4 Replies
- You could create a measure to calculate the percent of values and filter for within top 10%?
bhmiller89 , refer
Top 80/20 , percent /percentile
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
https://finance-bi.com/power-bi-pareto-analysis/
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/td-p/763156or
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finaleYou could try something like this:
Top 10% Customer = VAR Num = INT ( COUNTROWS ( Customer ) * 0.1 ) VAR Top10Customer = TOPN ( Num, Customer, [Total Sales], ASC ) RETURN Top10Customerbhmiller89
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 🙂
