Top 5 Bottom 5 measure does not filter Map visuals (Map, Azure Map)?

[smpa01]

Hi,

I have a measure to display top5 and bottom5 by variance on different cost sub category. I am using this measure as a visual level filter and it is doing its job to display top and bottom 5 business units in a matrix viz.

I also want to show top and bottom 5 on a map viz but unfortunately the visual level filter on map is not doing it's job. Is this normal? top5('000s) is ranking measure that produces the top and bottom 5 together.

[parry2k · Accepted solution]

@smpa01 maybe the way you calculated top/bottom 5 is based on the subcategory and when you are viewing it by lat/lng, it is not getting calculated as expected. If you just ignore map visual for now, just put the lat/lng in a table visual and filter on top/bottom 5, does it work? What values you are getting for these measures? You need to investigate it and fix your measure and I think that is the issue.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[smpa01]

@parry2k  thanks for showing me the debugging step. Yes you are right. With BU Name, lat, long on a matrix the measure fails

The following is my measure which does not filter the map but the previous matrix.

Budget Variance ('000s) := [Budget ('000s)]-[Actual ('000s)]

BU Decimal := CALCULATE(MAX(BU[BU]))/100000000000

Ranking TOP5 ('000s) := RANKX(ALLSELECTED(BU[Property_Name]),[Budget Variance ('000s)]+[BU Decimal],,DESC)

Ranking Bottom5 ('000s) := RANKX(ALLSELECTED(BU[Property_Name]),[Budget Variance ('000s)]+[BU Decimal],,ASC)

top 5 ('000s) := IF([Ranking TOP5 ('000s)]<6||[Ranking Bottom5 ('000s)]<6,1,0)

Is there any way to write a single measure that would work on both the viz

or

I need to transalate the existing ranking measure with lat and long to filter the map viz.