Forum Discussion
Rankx problem
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.
6 Replies
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
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-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
The result are 1 in all lines
wsuess , Tried this as a new column?
ItemRank = RANKX(ALL('Table'),'Table'[Part Number])
Hello Amit,
see both results.
