How to display top N values for items from different tables

[RyotNomad]

I have an access database with around 10 tables. The tables contain recordid which link them to my applicant table with the data that's relevant to my visual.

https://imgur.com/a/QnYUbqT

Currently it shows the count of the number of times '1' appears in each tables related row in the Applicant table. How do I make it show only the top 3 highest counts in the visual?

[V-pazhen-msft · Accepted solution]

@RyotNomad 

Power bi does not support rank value multiple fields.

The workaround for this issue is combining the 10 tables into 1 table, then you can create a rank by count of each city.

However, I am not sure whether it is feasible for you model.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

[amitchandak]

@RyotNomad 

Refer:https://community.powerbi.com/t5/Desktop/TopN/td-p/131646

https://www.oreilly.com/library/view/mastering-microsoft-power/9781788297233/378a5195-3e98-4cc1-bcd3...

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

[Greg_Deckler]

Use a Top N filter.