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
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello,

 

I want to create a new column ranking on the basis of certain values in a column (AHT). However, I want the ranking to be filtered according to the Date. I mean it should rank the values in AHT, if I filter the date to Jan-22 then it should give me ranking on the basis of date and not for overall dates.

 

EcodeEnameAHTDate
45654A382Jan-22
45655B289Jan-22
45654A351Feb-22

 

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Download my PBI file from here.  Let me know if this is working well.