Forum Discussion
Helper IIIRanking by Multiple Columns
| 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
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 🙂
3 Replies
- Fowmy
Super User
@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 🙂
- 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
mraka9Thanks Fowmy!
Great!
I also added the Case number to the formula.
Greeting
