Forum Discussion
Top X based on text field
Hello, I think this should be simple but I can't get it to work.
I'm looking to set a rank against how many times a string value features in a column.
EG if my column was
Yellow
Red
Yellow
Red
Blue
Yellow
Yellow would be rank 1 (as it features 3 times)
Red would be rank 2 (as it features twice)
Blue would be rank 3 (as it features once)
I seem to be able to get it working for fields with numbers, but not when I'm trying to count repeating string values like this
Thanks in advance
Anonymous
Please find below the Measure with the Ranking on the colors:Ranked = VAR TT = SUMMARIZE(ALL(Table2[Colors]),Table2[Colors],"Cnt", COUNTROWS(Table2)) RETURN MAXX(FILTER( ADDCOLUMNS(TT,"R", RANKX( TT, [Cnt])),Table2[Colors] = SELECTEDVALUE(Table2[Colors])), [R])________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
1 Reply
- Fowmy
Super User
Anonymous
Please find below the Measure with the Ranking on the colors:Ranked = VAR TT = SUMMARIZE(ALL(Table2[Colors]),Table2[Colors],"Cnt", COUNTROWS(Table2)) RETURN MAXX(FILTER( ADDCOLUMNS(TT,"R", RANKX( TT, [Cnt])),Table2[Colors] = SELECTEDVALUE(Table2[Colors])), [R])________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂