Rankx problem

[wsuess]

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

[amitchandak]

@wsuess , Have tried

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

I did not see that

[amitchandak]

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

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

or

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

or

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

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

[wsuess]

Hello Amit,

see both results.

[wsuess]

The result are 1 in all lines

[amitchandak]

@wsuess , Tried this as a new column?

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

[AlB]

Hi @wsuess 

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