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/

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 ? 

 

 
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

5 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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'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