Create a rank column by using values from other column in Power BI

Question

question

SaiharshavardhanRagyari-1083 asked May 21, '20 HarshNathani-6222 commented Jun 5, '20

Create a rank column by using values from other column in Power BI

I need to achieve rank column as below. Kindly help. Thanks in advance.

 Column1 Rank
 93           1
 93           1
 93           1
 92           2
 91           3
 87           4
 56           5
 34           6
 34           6
 34           6
 26           7
 15           8
 12           9
 9                  10

not-supported

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HarshNathani-6222 · Jun 05, 2020 at 07:58 AM

Create a supported Calculated Column

SUM1 = 'Table'[Column1]

and then use the rank function

Create another Calculated Column

RANK =

var a = RANKX('Table','Table'[SUM1])

RETURN
a

0 ·

1.jpg (26.9 KiB)

Answer 1 · 2020-05-21T07:31:17.137Z

VaibhavChaudhari answered May 21, '20

Currently Power BI related questions are not supported on this forum.

It's better to post the question in below dedicated forum:

PBI_Comm_Forums

If the response helped, do "Accept Answer" and upvote it - Vaibhav

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question