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 say when I select Only Branch B my output will be

 

StoreSpaceRank
BRANCH B25002

 

(Because Rank will be changed according to selection)

 

I want to keep Rank as my first data set though I selected One branch from the Slicer. ( I don't want to change Rank No)

 

Thank you,

Harsha

 

 

 

 

 

 

 

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.

     

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    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.