Top 10 on a map

[Anna_Korolyuk]

Hi!

I want to show top 10 items on a map and only them. I created rank measure with the help of RANKX, it works. Now the solution is to add measure filter to the visual filters as for example in here. But it doesn't work, filter is applied and map still shows all items, not only top 10. 

[v-lili6-msft]

hi, @Anna_Korolyuk

You may try this simple way:

Step1:

Create a Rank measure like this:

Rank = RANKX(ALLSELECTED(Table1),CALCULATE(SUM(Table1[Qty])),,DESC )

Step2:

Darg Rank Measure into visual level filter, and set filter is less than or equa to "XXX"

For example:

In my example, show top 3 result

Here is demo pbix file, please try it.

If not your case, please share your sample pbix file and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin

[Anna_Korolyuk]

Ok, I see my mistake. You use just maps, I used ArcGis maps. For ArcGis it doesn't work, for usual maps it does.

[v-lili6-msft · Accepted solution]

hi, @Anna_Korolyuk

When I use ArcGis maps, it also works well.

for example:

Top2Top4

So if you could share your sample pbix file with us, there should be something wrong in other setting.

Best Regards,
Lin

[Anna_Korolyuk]

While I was preparing map, I noticed that it works for ArcGis too. I must have somewhere wrong address (i have 100 of them) and that's why it doesn't work. Can't publish all addresses, but for small amount of them things work. Thank you, I have seen that I am doing right thing.

[v-lili6-msft]

hi, @Anna_Korolyuk

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Best Regards,

Lin