Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create New Column with RANKX DAX for ranking by multiple variable

Hi All,    I would like to create new column (Rank) using RANKX, this rank coloumn is group by multiple criteria (Type 1, Type 2, Month, and Year) then rank by the score. below are the sample of my...
Need Help
  • ThxAlot's avatar
    ThxAlot
    3 years ago
    Rnk = 
COUNTROWS(
    FILTER(
        DATA,
        DATA[Type 1] = EARLIER( DATA[Type 1] )
            && DATA[Type 2] = EARLIER( DATA[Type 2] )
            && DATA[year] = EARLIER( DATA[year] )
            && DATA[Month] = EARLIER( DATA[Month] )
            && DATA[Score] >= EARLIER( DATA[Score] )
    )
)

ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
3 years ago
Rnk = 
COUNTROWS(
    FILTER(
        DATA,
        DATA[Type 1] = EARLIER( DATA[Type 1] )
            && DATA[Type 2] = EARLIER( DATA[Type 2] )
            && DATA[year] = EARLIER( DATA[year] )
            && DATA[Month] = EARLIER( DATA[Month] )
            && DATA[Score] >= EARLIER( DATA[Score] )
    )
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This is working ! thank you very much!