TopN filter doesn't work as expected when chart explanation is applied

[Anonymous]

Can anyone please help answer the question related to this post:

https://stackoverflow.com/questions/62530159/topn-filter-doesnt-work-as-expected-when-chart-explanat...

Thanks in advance.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could use TOPN() function directly.

Here is my test file for your reference.

[amitchandak]

@Anonymous , Did not get it completely, see this filter

Top 10 City Rank = CALCULATE([Sales],TOPN(10,all(Geography[City]),[Sales],DESC),VALUES(Geography[City Id]))

For Rank Refer these links

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415