Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks Fowmy!
Great!
I also added the Case number to the formula.
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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
What have you tried so far? Here's a good article on the topic. RANKX on multiple columns with DAX and Power BI - SQLBI
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |