Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I am trying to rank products by sales. For some reason it is ranking products like a tie even though sales are different.
Formula: = RANKX(ALL(Sales[ Product Title]),[Total Net])
Picture(each line is a product):
Any help?
Hello @Anonymous,
Try this;
ProductRank = RANKX( ALL(Sales);CALCULATE(SUM(Sales[Net Sale]));;DESC)
Greets,
Ronald
That marked everything as 1. I dont need to take into account "product title" which would be the first coloumn in my picture?
Is what you posted orginally source data or how it looks in a table/matrix visual? If you can post sample source data that would be helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I have a sales table with a product on each line and multiple lines make up an order
Order # | SKU | Product | Category | Units | Net Sales | Date |
1 | 2345 | Product A | Red | 3 | $ 15.00 | 1/1/18 |
1 | 456 | Prouct B | Blue | 1 | $ 2.00 | 1/1/18 |
2 | 874 | Product C | Black | 2 | $ 8.00 | 1/1/18 |
3 | 456 | Prouct B | Blue | 1 | $ 2.00 | 1/1/18 |
3 | 8452 | Product D | Green | 2 | $ 6.00 | 1/1/18 |
4 | 2345 | Product A | Red | 5 | $ 25.00 | 1/1/18 |
So I want to see that Prouct A was number 1 with $40 and so on. I have hundreds of proucts and i want to be able to see top 10 by category.
User | Count |
---|---|
64 | |
59 | |
47 | |
32 | |
31 |
User | Count |
---|---|
84 | |
73 | |
52 | |
50 | |
44 |