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

      • ADP007's avatar
        ADP007
        Helper IV
        8 years ago

        Hi all,

         

        I have a reproduced the error in a report I can share

        When I unselect a date the ranking is wrong in the Card

        Any help always welcome

         

        Thanks

        D.