Forum Discussion

ADP007's avatar
ADP007
Helper IV
8 years ago
Solved

rank

Hello,

 

Havong difficulty with a rank formula 

Ranking-1 = RANKX(ALL('Media Agency'[Media agency Group]);CALCULATE([FY-1 Price]))

 

Result is correct when used in a matrix, when used in a Card with a visual filter on GroupM the result is different.

Live connection on a Tabular cube.

Any help more than welcome as always

 

Thanks

ADP

 

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi ADP007,

     

    It should be 11. The YYYYMM won't change the rank number as you need. You can't use the old measure as standards. 

    rank2

     

     

    Best Regards,

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi ADP007,

     

    Could you please mark the proper answers as solutions?

     

    Best Regards,

    Dale

11 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    ADP007

     

    What if you use ALLSELECTED??

     

    Ranking-1 = RANKX(ALLSELECTED('Media Agency'[Media agency Group]);CALCULATE([FY-1 Price]))

     

     

    • ADP007's avatar
      ADP007
      Helper IV
      8 years ago

      Hi,

       

      I tried that also. The result is ok in the matrix but then in the card the ranking is 1 and no longer 5. In both cases the ranking in the card is incorrect

       

      Thanks 

       

      .

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi ADP007,

         

        Can you share the formula of [FY-1 Price]? Share the file please if you can. BTW, how did you apply the visual level filter?

         

        Best Regards,

        Dale