Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Rank based on dimensional attributes

Hi All - hoping for some assistance here with Ranking on couple of dimensional attributes   I've a requirement to show top 10 projects that will have certain types of impact.   I've a table about...
COUNTROWS
DAX
Filter
power bi
RANKX
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Wow!! Are you suggesting to get only top N rows of the list, I need to write such a long complicated DAX?

     

    Isn't it an over kill?

    ..........Were my thoughts when I saw your response. But then I thought of trying it out.

     

    And it worked.

     

    Thanks a lot Greg_Deckler That was really helpful.

     

    Thanks

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      5 years ago

      Anonymous Glad someone could use that formula because it was a total PITA to write it!!