Top N + Others

[gauravnarchal]

What is the simplest way to get TOP N + Other sales figure in Power BI.

Can this be handled by filters?

[Fowmy]

@gauravnarchal 

Check this article from SQLBI : 

https://www.sqlbi.com/articles/showing-the-top-5-products-and-others-row/

________________________

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

I accept KUDOS ☺

YouTube | LinkedIn

[Anonymous]

if you intend to obtain two tables such that in the first there are the first n largest values and in the second the others, you can do so:

 tabSort=Table.Sort(Source,{{"sales", Order.Descending}})
TopN = Table. FirstN (tabSort, N),
others = Table.Skip (tabSort, N)

[gauravnarchal]

Is there a better way that you can advise to handle this requirement?

Can filters help to get top N + Other?

[Anonymous]

I know of other ways of achieving the same result.
If this is what you want, you should define more precisely what you mean by "better way".
Do you use less memory?
It's faster?
Do you use a single expression?
Other!?

[gauravnarchal]

1) Can we use filters to achieve Top N + others?

[Anonymous]

I'm sorry, but I can't help you

[parry2k]

@gauravnarchal there are tons of links/post on this and here is one.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[parry2k]

https://community.powerbi.com/t5/Desktop/Top-N-and-others-at-the-same-time/td-p/493040