Forum Discussion

CEllis's avatar
CEllis
Resolver I
2 years ago
Solved

Ranking using group and sum

Afternoon,   Is it possible to use a DAX statment to do ranking over a single table that resets at each change in grouping.   Source_Table Id Subject Cycle Result 10 Art 1 34 11 ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    CEllis , You can try below DAX

     

    RANK =
    RANKX(
    FILTER(
    Source_Table,
    Source_Table[Subject] = EARLIER(Source_Table[Subject]) &&
    Source_Table[Cycle] = EARLIER(Source_Table[Cycle])
    ),
    Source_Table[Result],
    ,
    ASC
    )

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

CEllis , You can try below DAX

 

RANK =
RANKX(
FILTER(
Source_Table,
Source_Table[Subject] = EARLIER(Source_Table[Subject]) &&
Source_Table[Cycle] = EARLIER(Source_Table[Cycle])
),
Source_Table[Result],
,
ASC
)

CEllis's avatar
CEllis
Resolver I
2 years ago

Thanks bhanu_gautam keep forgetting this needs to be a new column not measure to work.