Top X based on text field

[Anonymous]

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

[Fowmy · Accepted solution]

@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 🙂

YouTube  LinkedIn