rank not working in tooltip

[almohalhel1408]

hello everybody 

i am trying to get the ranking for countries which one The most affected country by corona 

so i did the measure correctly https://powerbi.tips/2017/07/ranking-values-with-measures/

it is working in the tables but then i made it like a card in tooltip page so when i tried in the map it was not filtering correctly

rank in table working correctly

 and here when i put it like a card in tooltip 

rank not working in tooltip

 is there any solution ? 

[v-lili6-msft]

hi  @almohalhel1408 

Just replace ALL instead of ALLSELECTED in the rank measure.

Since when you use a tooltip page and it likes you use a slicer to filter the data, so it will always return 1.

Regards,

Lin

[almohalhel1408]

first i appreciate your help @v-lili6-msft @amitchandak 

so i replaced ALL instead of ALLSELECTED in the rank measure like that 

Rank = RANKX( ALL('Cases Time (2)'[Country Region] ) , CALCULATE( SUM( 'Cases Time (2)'[Delta_Confirmed]) ) )

but the result same exactly like above in the table working well but in tooltip not working

i discovered something maybe it will help to configure the problem i found that when i use the Country Column in the same table of measure it will working but when i use Location Table to Filter the result it will give me a wrong result

Relationship

 rank is working if i used Country column in the same table for the value

 here i created a map with Country Column  from the Case Time Table so 

ranked function worked well but the others with yellow highlight disabled not working any more and this Expected to happen

so what i have to do now?

[v-lili6-msft · Accepted solution]

hi  @almohalhel1408 

You need to use field from "Location" in the rank formula.

use a tooltip page, it likes that you use drillthrough from that map visual to tooltip page, then it will filter that country in tooltip page.

so it will show only one country data in tooltip page.

Therefore, you could only all instead allselected function, but if you use slicer filter data in report, it will be covered by tooltip, so it will always rerturn 1 when you use allselected.

Regards,

Lin

[almohalhel1408]

First of all thanks million for helping me really i learned many things 

second thing i made many experiments and you right about ALL and ALLSELECTED 

SO FINALLY i discovered the main problem with rank with map 

if i made the map field take a data from Country column in Location Table then the measure it will work fine but if i made the map take the data from Lat and Long cordinate Columns then the Rank Measure it will not work

so any solution 

[amitchandak]

@almohalhel1408 

Is data displayed at the same granularity as the bar chart?