Display all items and Top N based on user input

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@Anonymous,

Here is an article for your reference.

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

[v-chuncz-msft · Accepted solution]

@Anonymous,

Here is an article for your reference.

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

[Anonymous]

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 · Accepted solution]

@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...