Forum Discussion

zflory's avatar
zflory
Icon for Helper I rankHelper I
8 years ago
Solved

RANKX 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, th...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

zflory's avatar
zflory
Icon for Helper I rankHelper I
8 years ago

The 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's avatar
zflory
Icon for Helper I rankHelper I
8 years ago

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