Hierarchy Ranking

[Anonymous]

Hi All,

Please help with the ranking if we have a product table(with hierarchy) and a sales table. I want to rank on the product hierarchy based on sales and it should show the rank at each level when drilling down.

Thanks in advance!

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

This seems to answer your question. https://community.powerbi.com/t5/Desktop/Rank-measure-with-hierarchy-drill-down/td-p/543380


If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous]

Hi @Nathaniel_C ,

Thanks for your help!