Tooltip page is losing context, please help

[Anonymous]

OK - so I have a formula that takes all filtered and shown criteria and ranks the filtered data.  

AS a tooltip this works no problem.  As a report page tooltip this breaks and loses the context of the filtered area.  Please tell me I can do this.

Map is created using Lat and Long - when you hover over, the calculations work in the tooltip section.  But when this same calculation is used on a tooltip page, hovering over the City (in this case) causes the tooltip page to filter down to JUST THAT CITY.  This is why my ranking is breaking.

I have copied over all slicers to the tooltip page, I have synced them, I have tried many things but this does not seem like it's going to work.  Thoughts?  

This is a ranking calculation so it is very important to include any selection of data you want.  So I can't precreate the rank since the rank could change to anything based on whatever your selection is.  

In the below picture - the bubble colors are based on Rank or ProdByCity - same calculation copied below.  you can see that there are different colors, but my tooltip only shows RankCity = 1 and ProdbyCity = P...  well that's wrong.

I don't think there is anything I need to add to my measure below - like saying "All(this column)" - there are no more "this columns" I can add.  What I am hoping for is something that I can say "remember context" or somehow not filter the page down to just one city on those two measures.

Here is the calculation:

ColorFilterByCity = 
var _idave = selectedvalue(ProductivityByCity[Avg OF ID City])
var _Cat = ALLSELECTED(Equipment[ProductCategory])
var _mod = ALLSELECTED(Equipment[ProductModel])

var RankbySubcat2 = if(isblank([Wkld - City]),Blank(),
round(CALCULATE(Rankx(
ALLSELECTED(ProductivityByCity)
,[Wkld - City]
,
,Desc
,Skip)
,ALLSELECTED(Equipment)
,ALLSELECTED(ProductivityByCity[Avg OF ID City])

),2))

var mcocount = calculate(calculate(DISTINCTCOUNT(ProductivityByCity[CityState])

,filter(ProductivityByCity,[Wkld - City]<>blank())

,ALLEXCEPT(ProductivityByCity,ProductivityByCity[Avg OF ID City],ProductivityByCity[CityState],ProductivityByCity[EntityState])

,ALLEXCEPT(DistrictMCO,DistrictMCO[MCO],DistrictMCO[District]))


,ALLEXCEPT(ProductivityByCity,ProductivityByCity[Avg OF ID City],ProductivityByCity[CityState],ProductivityByCity[EntityState])

)

Var result = 
round(Divide(RankbySubcat2-1,mcocount),2)
var final = if(isblank([Wkld - City]),Blank(),if(result<=0.2,0.0,if(result<=0.7,0.7,if(result<=1,1)))) -- 3 Layer View

return
final

 
@amitchandak @Sahir_Maharaj @Greg_Deckler @Padycosmos @lbendlin  - if any of you want a challenge or know the answer 🙂

[lbendlin]

Please provide a couple of sample locations and their value to be ranked against.

[Padycosmos]

This video might help with regard to the rank being in scope:

https://www.youtube.com/watch?v=y2FFjfRD-Bo