Forum Discussion
Helper IRANKX 1-25
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
Super UserI 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
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