Forum Discussion
Display all items and Top N based on user input
Hi Team, I am trying to build Power BI report to display all sales in a month and when selected with user level filter need to display top 10, 50 and 100 sales by city. Can you please help provi...
Anonymous,
Here is an article for your reference.
Anonymous
you can use this formula to achive your query...
Rank = IF(ISBLANK([TopN SubCat]), BLANK(), RANKX(ALLSELECTED(Orders[Sub-Category]), [Total Sales]))
If it is solution to your query, Pls accept as solution.. it is helpfull to others...
Hi Sam,
Thanks for the solution, It worked.
however is it possible to show rank values like 1,2,3,4 for the same in new column
venug20
Resolver I
Resolver IAnonymous
you can use this formula to achive your query...
Rank = IF(ISBLANK([TopN SubCat]), BLANK(), RANKX(ALLSELECTED(Orders[Sub-Category]), [Total Sales]))
If it is solution to your query, Pls accept as solution.. it is helpfull to others...