Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
There are few posts and a blog that discuss this.
https://community.powerbi.com/t5/Desktop/DAX-Ranking-within-a-group/td-p/261079
https://powerpivotpro.com/2015/06/rankx-apalooza-within-and-across-groups-with-filters-etc/
There is nothing to stop you having multiple Rank Measures.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |