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

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

       

      • ADP007's avatar
        ADP007
        Helper IV
        8 years ago

        Hi Dale,

         

         [FY-1 Price] is a calculated measure in my tabular model 

        FY-1 Price:=CALCULATE
 (
    [TotalPrice];
    FILTER(Calendar;Calendar[MDB_FYIndex] =  -1 )
)

        I have a DimDate table where some index give running year, last year etc....

         

        How can I share the file with you?

        Regards

        David