Forum Discussion

saranee's avatar
saranee
Icon for Helper I rankHelper 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
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity 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
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Zubair_Muhammad Thanks for the solution, it worked seamlessly.