Forum Discussion

Jim123456789jim's avatar
Jim123456789jim
Frequent Visitor
8 years ago

DAX Rank()

Hi All,   I have created a table report with columns coming from Excel.   Player   Matches Avg  StrikeRate  Runs Rohit     102         34     135            4500 Paul       112         32     1...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Jim123456789jim

 

Try this as a calculated column

 

RANK =
IF (
    Batsmen[Criteria] = 1,
    RANKX ( FILTER ( Batsmen, Batsmen[Criteria] = 1 ), [Runs],, DESC, DENSE )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Jim123456789jim

 

As a Measure

 

RANK Measure =
IF (
    SELECTEDVALUE ( Batsmen[Criteria] ) = 1,
    RANKX (
        FILTER ( ALLSELECTED ( Batsmen ), Batsmen[Criteria] = 1 ),
        CALCULATE ( MAX ( Batsmen[Runs] ) ),
        ,
        DESC,
        DENSE
    )
)