Forum Discussion
Top 10 on a map
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.
hi, Anonymous
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
5 Replies
hi, Anonymous
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
hi, Anonymous
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