Forum Discussion

saranee's avatar
saranee
Helper I
8 years ago
Solved

Dynamic ranking based on date

Hi all,   Request your help on this.   We are basically having a table with Name,Date and based on date we are assigning Rank. We have calculated column to calculate rank:RANKX(FILTER(Table1,Tab...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    saranee

     

    Try this MEASURE for dynamic RANKING

     

    RANK =
RANKX (
    FILTER ( ALLSELECTED ( Table1 ), Table1[Name] = SELECTEDVALUE ( Table1[Name] ) ),
    CALCULATE ( SELECTEDVALUE ( Table1[Date] ) ),
    ,
    DESC,
    DENSE
)
saranee's avatar
saranee
Helper I
8 years ago

HI Richard,

 

We will be then unable to use EARLIER in measure.Please can you suggest some alternative as we want seperate set of names and then trying to find rank.

 

Thanks,

saranee

ricardocamargos's avatar
ricardocamargos
Continued Contributor
8 years ago

Hi saranee,

 

Try this code:

 

_Index =
IF(ISBLANK(CALCULATE(COUNTROWS(Table2); FILTER(ALLSELECTED(Table2[Date]); Table2[Date] < MAX(Table2[Date]))));
1;
CALCULATE(COUNTROWS(Table2); FILTER(ALLEXCEPT(Table2; Table2[Name]); Table2[Date] < MAX(Table2[Date]))) + 1)

 

Ricardo

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    saranee

     

    Try this MEASURE for dynamic RANKING

     

    RANK =
RANKX (
    FILTER ( ALLSELECTED ( Table1 ), Table1[Name] = SELECTEDVALUE ( Table1[Name] ) ),
    CALCULATE ( SELECTEDVALUE ( Table1[Date] ) ),
    ,
    DESC,
    DENSE
)
      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        8 years ago

        Hi rishikdutta1987,

        Please mark the right solution as answer, so more people like you can find the solution easily.

        Best Regards,
        Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Zubair_Muhammad Thanks for the solution, it worked seamlessly. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Kudos on this solution