Filter table desc with condition

Hi hylosko ,

Did you try to apply TopN filters to the visualization like:

But as my data sample shown, there may be several same values , so the Top 3 have 4 rows. In this case, if you just want to display 3 rows, you may rank by Profit firstly and then rank by a column with unique value like project_name.

Assume there are less than 100 rows:

Flag = RANKX(ALLSELECTED('Table'),CALCULATE(MAX('Table'[PROFIT])),,DESC,Dense) *100 + RANKX(ALLSELECTED('Table'),CALCULATE(MAX('Table'[PROJECT_NAME])),,DESC,Dense)

Measure = RANKX(ALLSELECTED('Table'),[Flag],,ASC,Dense)

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.