Syntax
TOPN(<N_Value>, <Table>, <OrderBy_Expression>, [<Order>[, <OrderBy_Expression>, [<Order>]]…]) Tutorial with example
It is very useful and common practice to be able to group data in Power BI by the, for example, top 5 and then group the remaining categories in a new category called Other.
Unfortunately, Power BI does not have this capability so we need to recreate it manually.
Let me show you here one way to do it.
Watch the tutorial:
Links to the mentioned resources
To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #132
Was this helpful?
Leave a Reply