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
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Actuall, I see what you are after.  I will post the calculation in an hour.  I just have to head out the door. :)

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
    )
)