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 providing some examples with DAX functions
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...
3 Replies
v-chuncz-msftCommunity Support
Anonymous,
Here is an article for your reference.
venug20Resolver I
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...