topic Re: Rankx problem in DAX Commands and Tips

Rankx problem

wsuess — Mon, 21 Dec 2020 11:11:33 GMT

Hi to all,

I have problem with RankX, because the data formart, which i have to rank are text.See below screen shot

I have a second table, which i rank and there i can use it without problems, but these are decimal numbers.

ItemRank = RANKX(ALL('DataTable'[Part Number]),'DataTable'[Revenue1])

Is there any solution for?

Many thansk for your support

AlB — Mon, 21 Dec 2020 11:52:33 GMT

What is the problem exactly?

How would you like to sort/rank the text data? Following what rules?

Probably best to convert the text to number in a way that respects the order you want to observe

And best if you can share the pbix or some sample data like that shown in the pic but in text format so that it can be readily copied

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

amitchandak — Mon, 21 Dec 2020 11:58:26 GMT

wsuess , You should able to rank, what is error you are getting

ItemRank = RANKX(ALL('Table'[Part Number]),'Table'[Part Number])

ItemRank = RANKX(ALL('Table'),'Table'[Part Number])

ItemRank = RANKX(ALL('Table'),'Table'[Part Number],,asc,dense)

wsuess — Mon, 21 Dec 2020 12:02:52 GMT

The result are 1 in all lines

amitchandak — Mon, 21 Dec 2020 12:50:59 GMT

wsuess , Tried this as a new column?

ItemRank = RANKX(ALL('Table'),'Table'[Part Number])

wsuess — Mon, 21 Dec 2020 13:08:42 GMT

Hello Amit,

see both results.

amitchandak — Mon, 21 Dec 2020 15:44:46 GMT

wsuess , Have tried

ItemRank = RANKX(ALL('Table'),'Table'[Part Number])

I did not see that