Forum Discussion

almohalhel1408's avatar
almohalhel1408
Frequent Visitor
6 years ago
Solved

rank not working in tooltip

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...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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's avatar
almohalhel1408
Frequent Visitor
6 years ago

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's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    almohalhel1408
    Frequent Visitor
    6 years ago

    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