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 r
If 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! 🤠
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 r
If 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! 🤠
thank 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?
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
