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, bu...
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
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.
