In this post I will show you how you can find TOP 2 products under each region sales wise in Power BI using DAX function.
Refer similar post: TOP N Filter
Let’s get started-
Download the sample Dataset from below link-
Follow these steps in order to get TOP 2 products under each region-
Step-1: Drag three columns into Table visual – Region, Product name & Sales.
Dataset format
Step-2: Create a measure for Total Sale.
Total Sales = SUM('Global-Superstore'[Sales])
Step-3: Create one more measure to get TOP 2 Products
Top 2 Prodcuts = Var GetProducts = VALUES('Global-Superstore'[Product Name]) Return CALCULATE([Total Sales], TOPN(2, ALL('Global-Superstore'[Product Name]), [Total Sales]), GetProducts)
VALUES: It returns one column table with distinct values from specified column.
ALL: Returns all the rows in a table, or all the values in a column, read in details…
TOPN: Returns the top N rows of the specified table.
Step-4: Now drag measure column in Table visual in place of Sales column.
TOPN DAX
In above screen shot you can see the final result, it is showing TOP 2 selling products under each region.
Other DAX functions: DAX functions
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.