cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## RANX showing different values as ties

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?

4 REPLIES 4
Resolver III

Hello @Anonymous,

Try this;

```ProductRank = RANKX(
ALL(Sales);CALCULATE(SUM(Sales[Net Sale]));;DESC)```

Greets,

Ronald

Anonymous
Not applicable

That marked everything as 1. I dont need to take into account "product title" which would be the first coloumn in my picture?

Super User

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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.

Announcements