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

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI Jim123456789jim

 

I belive this is what you are after.  This is a calculated column

 

My Rank = 
            CALCULATE(
                COUNTROWS('Table') ,
                FILTER(
                    'Table',
                    EARLIER('Table'[Runs]) > 3000 && 
                    EARLIER('Table'[Avg]) > 30 && 
                    EARLIER('Table'[Matches]) > 100 && 
                    EARLIER('Table'[StrikeRate]) > 130),
                'Table'[Runs] <= EARLIER('Table'[Runs])
                )