Forum Discussion
Helper IRANKX 1-25
Hello
Very new user here with a question. I am trying to get a constant 1-25 ranking down the left hand side of this data table. That way, if I sort by either Volume or Plant Margin by Volume, the numbers 1-25 will still be in descending order down the left hand side and the accounts will change (based on Volume or Plant Margin by Volume). Can anyone assist? This is the DAX I have come up with so far
Rank = RANKX('Customer',[$/volume 2017],,DESC)
Hi zflory,
For your scenario, you can add a rank column to calculate the rank, then drag this to visual level filter, switch to advanced mode with 'is less than or equal to' and input 25 as filter range.
BTW, calculated column not works with slicer and filter, if you want to achieve the dynamic rank or effect with other filters, you need to use measure to instead.
Regards,
Xiaoxin Sheng
4 Replies
- TomMartens
Super User
Hey,
I have to admit that I do not understand what you are looking for. Please prepare an Excel file with sample data, and also the expected result. Upload the file to onedrive or dropbox and share the link.
Maybe this link will also help
https://www.wiseowl.co.uk/blog/s2469/rankx-function.htm
Regards
Tom
zfloryThe below data table is what I'm working with. I would like to have numbers 1-25 in descending order down the left side of the matrix. That way, when I sort by either Volume or Plant Margin by Volume, the numbers will stay in constant order (1-25) and I will be able to determine the top 25 customers (in order) or either of those metrics (Volume or Plant Margin by Volume). I apologize, I should have included the matrix in my original post
- zflory
Also, when doing my RANKX measure, is it only possible to use calculated columns in the expression argument of the measure? I am wanting to add volume from my orignnal data sheet in that argument, but Power BI is only letting me include calculated columns
