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
« Back to Index
Was this helpful?
Let us know your thoughts...