Forum Discussion

guenfood's avatar
guenfood
New Member
4 years ago
Solved

Rank by index

Hi,   I've got a table with an index column. To display many text informations in cards, i create measures which could display values according to ranking position. But this ranking position must...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi guenfood ,

     

    According to your description, I did the test reference as follows:

    Column = 
"Rank"
    & RANKX (
        FILTER (
            ALL ( 'Table (2)' ),
            'Table (2)'[Index] = EARLIER ( 'Table (2)'[Index] )
        ),
        [Value],
        ,
        ASC,
        DENSE
    )


    If I have misunderstood your requirements, please point out and provide some test data and screenshots of the desired results so that I can fix them as soon as possible. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi guenfood ,

 

According to your description, I did the test reference as follows:

Column = 
"Rank"
    & RANKX (
        FILTER (
            ALL ( 'Table (2)' ),
            'Table (2)'[Index] = EARLIER ( 'Table (2)'[Index] )
        ),
        [Value],
        ,
        ASC,
        DENSE
    )


If I have misunderstood your requirements, please point out and provide some test data and screenshots of the desired results so that I can fix them as soon as possible. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.