Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Filter top 3 products with a row for others using DAX in Power BI

SQLBI
120K subscribers
92K views 4 years ago
This video shows an optimized DAX technique to display the first N products for each category in Power BI, adding a row that aggregates the value for all the other products. Article and download: https://sql.bi/695263/?aff=yt The article includes further insights and optimization solutions, whereas the video introduces the scenario and explain the simpler formulas. How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... ...more
...more
Filter top 3 products with a row for others using DAX in Power BI
1.9KLikes
92,395Views
2021Jan 4
This video shows an optimized DAX technique to display the first N products for each category in Power BI, adding a row that aggregates the value for all the other products. Article and download: https://sql.bi/695263/?aff=yt The article includes further insights and optimization solutions, whereas the video introduces the scenario and explain the simpler formulas. How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

Follow along using the transcript.

SQLBI

120K subscribers