Forum Discussion

harshaSampath81's avatar
harshaSampath81
Icon for Helper II rankHelper II
7 years ago
Solved

Rank change according to selection

I am using Rank function    Rank = RANKX ( ALLSELECTED ( Table1[STORE] ), CALCULATE ( SUM ( Table1[SPACE] ) ) )   my question is how do I keep Rank as it is when I select  Branch B. simple...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    harshaSampath81,

     

    You can use calculate column instead of measure.

    Rank Column = RANKX(Table1, Table1[SPACE])

    Or you can modify your measure like below.

    Rank Measure = RANKX(ALL(Table1), CALCULATE(SUM(Table1[SPACE])))

      

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.