Forum Discussion
Helper IIUsing RANK and SWITCH together
My SWITCH statement works properly but I need to RANK the results within a Heirarchy. I have Territory_Managers and then Salespeople grouped below them. How do I rank each group of salespeople within their territory.
output :
ranking = var datasource = CALCULATETABLE( SUMMARIZE( table_1, table_1[territorymanager], table_1[salespeople] ), REMOVEFILTERS(table_1[salespeople]) ) var r = RANK( , datasource, ORDERBY([total sales] , desc ) ) return rIf my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
3 Replies
- Daniel29195
Community Champion
output :
ranking = var datasource = CALCULATETABLE( SUMMARIZE( table_1, table_1[territorymanager], table_1[salespeople] ), REMOVEFILTERS(table_1[salespeople]) ) var r = RANK( , datasource, ORDERBY([total sales] , desc ) ) return rIf my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
RevOps608thank you! It's working....mostly. It works fine for anything < 100%. Any idea why anything over would throw it off and do you have a solution?
- RevOps608
It was my FORMAT that was making the difference. Unsure why my % via FORMAT was different then just marking the SWITCH as a %. Maybe it was a text string?
Thanks