Ranking by Multiple Columns

[mraka9]

Case Number	Group	Item	Price	Manufacturer	RANK
100-00	1	1	10,00	xx	1
100-00	1	1	10,50	yy	2
100-00	1	1	11,00	xy	3
100-00	2	1	20,00	xy	2
100-00	2	1	18,00	xx	1
100-00	2	1	25,00	yy	3
101-00	3	1	1,00	xx	1
101-00	3	1	1,50	yy	2
101-00	3	2	7,00	yy	2
101-00	3	2	5,00	xy	1
101-00	3	3	9,00	xx	2
101-00	3	3	8,00	yy	1

Hello everyone!

I need help!
I want to get a Rank column!

Price is a ranking criterion, but ranking based on item number, group, and item is required.

Thus, an identical number of items, group, and item are the ranking criteria.

Thank you in advance!

Greeting!

[mraka9]

Thanks Fowmy!

Great!

I also added the Case number to the formula.

Greeting

[Fowmy · Accepted solution]

@mraka9

Add the following formula as a new column to the table:

Rank = 
RANKX(
    FILTER(Table5,Table5[Group] = EARLIER(Table5[Group]) && Table5[Item] = EARLIER(Table5[Item])),
    Table5[Price],,ASC
)

________________________

If my answer was helpful, click OK as the solution to help other members find it useful

Click the Thumbs-Up icon if you like this answer 🙂

Website Youtube Linkedin

[lbendlin]

What have you tried so far?  Here's a good article on the topic. RANKX on multiple columns with DAX and Power BI - SQLBI