Ranking according to category level

[riadorra]

Hi,

How can i rank products by sale according to the category level displayed on the graphic/visual?

Ex: I have 2 tables, one is the product register table and the other contain sales by product

The register table contain 2 levels (Product name and Supplyer) and other table contains date, Product name and sales ...

Is it possible to view the rank by Product and by Supplyer?

Thank you

Riad

[v-jiascu-msft]

Hi Riad,

@stretcharm has given the advisory advice. If you want the exact formulas for your scenario, please post a sample. Because the relationship and data model structure could affect the result. Please mask the confidential part first.

Best Regards,

Dale

[stretcharm]

There are few posts and a blog that discuss this.

https://community.powerbi.com/t5/Desktop/DAX-Ranking-within-a-group/td-p/261079

http://community.powerbi.com/t5/Desktop/DAX-RANKX-how-can-I-get-unique-rank-by-categories/td-p/24229...

https://powerpivotpro.com/2015/06/rankx-apalooza-within-and-across-groups-with-filters-etc/

There is nothing to stop you having multiple Rank Measures.