topic Re: Rank based on dimensional attributes in DAX Commands and Tips

Rank based on dimensional attributes

Anonymous — Mon, 23 Aug 2021 02:24:01 GMT

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 projects and go live dates and impacts looking like this (dates are dd/mm/yyyy)

Since the table creation in this forum cannot be more than 10 rows, for argument's sake lets work on top 5

So from above the requirement is just to show the top 5 entries. Upto Project5. I dont want the remaining entries.

Hope that is sufficient info to help me out.

Thank you

Greg_Deckler — Mon, 23 Aug 2021 02:33:58 GMT

Where is the ranking coming from? Is it in the table?

Anonymous — Tue, 24 Aug 2021 09:51:26 GMT

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 — Tue, 24 Aug 2021 12:51:36 GMT

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