DAX Rank()

HI,

Thanks for your reply, but this solution is not helping. Reason, I want to give rank after filtering. For ex,

Assume the orginal table in this order,

Player   Matches Avg  StrikeRate  Runs

Rohit     102         34     135            4500

Rica        98          38      137            4645  --- Rica will be rejected as Matches is less than 100

Paul       112         32     140             4567

I want the below as the output in the table visualization after filtering with the DAX condition

Criteria = If( and(AND( and (Batsmen[SR]>130, batsmen[avg]>30),batsmen[mat]>100),batsmen[runs]>3000),1,0)

Rank Player   Matches Avg  StrikeRate  Runs

  1    Paul       112         32     140             4567

  2     Rohit     102         34     135            4500

Reason , I want to apply Rank only to those rows which satisfy the condition Batsmen[SR]>130, batsmen[avg]>30),batsmen[mat]>100,batsmen[runs]>3000 and order by Runs Descending.

Now, if I apply your formula. The output will be

Rank Player   Matches Avg  StrikeRate  Runs

2    Rohit     102         34     135            4500

3     Paul       112         32     140             4567

Even if I change your DAX to descending, the output is,

Rank Player   Matches Avg  StrikeRate  Runs

2     Paul       112         32     140             4567

3    Rohit     102         34     135            4500

Note : I'm looking to give RANK to the rows in the Report to only those rows which satisfy the filtering condition. Pls suggest how to go about it.

Thanks!!

Reason, as per the original data (without filtering) Rica is having maximum Runs followed by Paul and Rohit