Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 Yel...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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

     








Fowmy's avatar
Fowmy
Super User
5 years ago

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