Forum Discussion

hylosko's avatar
hylosko
Helper III
4 years ago
Solved

Filter table desc with condition

Hello !   I want to filter my table by profit desc and show only values where total sum of dev_num = 30 i mean for example:   Dev_num  |   Profit 10                 100000 10                  ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi hylosko ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Best Regards,
Eyelyn Qin