Forum Discussion

Everton's avatar
Everton
Icon for Helper I rankHelper I
3 years ago
Solved

Rank within group

Hi, I want to rank within a group. First group by Id then rank by MostRecentUpdate. This is how I want the data to look.  Id InvoiceNumber InvoiceDate InvoiceStatus Owing MostRecentUp...
Help
  • tamerj1's avatar
    tamerj1
    3 years ago

    Everton 
    You mean like this?

    RankInGroupTest = 
IF (
    NOT ISEMPTY ( data ),
    RANKX ( 
        CALCULATETABLE ( 
            data,
            ALLEXCEPT ( Data, data[ID] )
        ),
        CALCULATE ( SELECTEDVALUE ( data[MostRecentUpdate] ) ),, 
        DESC, 
        Dense
    )
)
Everton's avatar
Everton
Icon for Helper I rankHelper I
3 years ago

Thank you again tamerj1 . I was wanting to group by Id and rank within that group. I have tried to highlight the groups in the below image: 

For example, withing the group with Id "e0ea3584-cd74-ed11-ac20-d8e2df0c6786" there should be rank 1,2,3. Rank 1 will be the latest MostRecentUpdate. 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Everton 
You mean like this?

RankInGroupTest = 
IF (
    NOT ISEMPTY ( data ),
    RANKX ( 
        CALCULATETABLE ( 
            data,
            ALLEXCEPT ( Data, data[ID] )
        ),
        CALCULATE ( SELECTEDVALUE ( data[MostRecentUpdate] ) ),, 
        DESC, 
        Dense
    )
)
  • Everton's avatar
    Everton
    Icon for Helper I rankHelper I
    3 years ago

    tamerj1 , perfect thank you!