Ranking based on measure

Hi Vish24 ,

At first, you need to add an index coloumn in the query editor.

Then refer to the following measure:

Measure =
MINX (
    FILTER (
        SELECTCOLUMNS (
            ALLSELECTED ( 'Table' ),
            "index", 'Table'[Index],
            "rank", RANKX ( ALLSELECTED ( 'Table' ), 'Table'[Column2],, DESC, DENSE )
        ),
        [index] = MAX ( 'Table'[Index] )
    ),
    [rank]
)

Here is my test file for your reference.