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

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

 

 

Anonymous's avatar
Anonymous
Not applicable
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