Forum Discussion
RankX using filter within column
Hello, I am relatively new to PBI. I'm trying to add a measured column that will rank price points from highest to lowest within each product listed in the product Column. The "Price Ranking"is the measure that I want to achieve: I've tried ranking using a filter and variable but my dax logic continually has errors. Any help is appreciated. Thanks!
| Product | Price | Price Ranking |
| A-10 | 225.01 | 1 |
| A-10 | 151.89 | 2 |
| A-10 | 129 | 3 |
| A-10 | 121.23 | 4 |
| A-10 | 120.27 | 5 |
| A-10 | 118.06 | 6 |
| A-100 | 202.97 | 1 |
| A-100 | 154.52 | 2 |
| A-100 | 67.47 | 3 |
| A-150 | 184.09 | 1 |
| A-150 | 133.61 | 2 |
JeanMariePBI check these posts
very well explained and you should be able to use it in your solution.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
JeanMariePBI ranking in subcategory with RANKX measure
_maxPrice = MAX('Table 1'[Price]) _rank = VAR _max= MAX('Table 1'[Product]) RETURN RANKX(FILTER(ALLSELECTED('Table 1'),'Table 1'[Product]=_max),[_maxPrice],,DESC)
4 Replies
JeanMariePBI ranking in subcategory with RANKX measure
_maxPrice = MAX('Table 1'[Price]) _rank = VAR _max= MAX('Table 1'[Product]) RETURN RANKX(FILTER(ALLSELECTED('Table 1'),'Table 1'[Product]=_max),[_maxPrice],,DESC)Thank you so much! It works great.
JeanMariePBI check these posts
very well explained and you should be able to use it in your solution.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Works perfectly! Thank you so much!
