Rank

[Anonymous]

Hi,

I want to rank my table having sales value, clientid and year such that it shows me rank of clients based on there salesvalue for each year.

Kindly help me to write dax to achieve the same.

Thanking in anticipation.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Please try this [Rank] measure:

Rank =
RANKX (
    ALLEXCEPT ( 'Client sales', 'Client sales'[Year] ),
    CALCULATE (
        SUM ( 'Client sales'[SalesValue] ),
        ALLEXCEPT ( 'Client sales', 'Client sales'[Clientid], 'Client sales'[Year] )
    ),
    ,
    DESC,
    DENSE
)

Best regards,

Yuliana Gu

[Anonymous · Accepted solution]

Thanks a lot for help..It works..

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Please try this [Rank] measure:

Rank =
RANKX (
    ALLEXCEPT ( 'Client sales', 'Client sales'[Year] ),
    CALCULATE (
        SUM ( 'Client sales'[SalesValue] ),
        ALLEXCEPT ( 'Client sales', 'Client sales'[Clientid], 'Client sales'[Year] )
    ),
    ,
    DESC,
    DENSE
)

Best regards,

Yuliana Gu

[Anonymous · Accepted solution]

Thanks a lot for help..It works..

[bizbi · Accepted solution]

Hello Honey,

That's the same solution I updated 2 days ago. It's only the data I used which is different. Please mark it as an accepted solution too in case you agree, else request you to notify me as to what could have been better.

Thanks in advance!

[Anonymous]

Hi , 

Table with dummy data that i am using is below, need to rank them:

 

[bizbi]

Hope this helps!