Top 10 in a report Power BI
Published on Jun 12,2023:
In this video, we will learn to find and filter on the top N sales by product name.
This logic can be extended to any other dimension. Please find the steps to be used below.
1. Sum Sales Amount =sum(FactInternetSales[SalesAmount])
2. Sales Amount Rank by Product = RANKX(ALLSELECTED(DimProduct[EnglishProductName]),[Sum Sales Amount])
3. Units Sold Top 15 Product = IF([Sales Amount Rank by Product] (add LT here) 15, [Sum Sales Amount])
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
/ @learnexcelrelentless
Our Playists:
SQL Playlist :https://goo.gl/PS5Ep6
DAX PlayList : https://goo.gl/S4W41D
Power BI PlayList: https://goo.gl/dXxvnB
Power Query Playlist: https://goo.gl/5QS7P4
Getting Started with Power BI:https://goo.gl/GHakLZ
Getting Started with Python: https://goo.gl/n24P3w
ABOUT DAGDOO:
Website:
Home Page: http://www.dagdoo.org/
Power BI Tutorials: http://www.dagdoo.org/excel-learning/...
Questions? Comments and SUGESTIONS? You will find me here:
Twitter: @dagdooe
Category: Science & Technology
License: Standard YouTube License
