Forum Discussion
Solved
Rankx based on table column
Hi there, I have data which looks like the following: ID No of Customer AX168 1081 FH5308 1046 CH2008 551 FK7784 1336 WK2752 1456 QT5202 390 AT7642 525 AB4 ...
Greg_Deckler , I followed the article and changed my code to the following:
ICP Rank = RANKX( ALL('Table'),[ICP],,DESC)
But it still gave me an error that 'The value for ICP cannot be determined. Either the column does not exist, or there is no current row for this column'.
Dunner2020 - You need an aggregator around it like SUM, MAX, etc.