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] )
    )
)

mlsx4's avatar
mlsx4
Memorable Member
3 years ago

Hi Anonymous 

 

This should work:

 

sumSC= SUM(Table[Score])

RANX Total= 
RANKX(
ALLEXCEPT('Table','Table'[Type 1],'Table'[Type 2],'Table'[Month],'Table'[year]),[sumSc],,DESC
)