Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
93 | |
83 | |
77 | |
70 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |