Rank change according to selection

[harshaSampath81]

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

Store	Space	Rank
BRANCH B	2500	2

(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

[v-yuta-msft · Accepted solution]

@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.

[Zubair_Muhammad]

@harshaSampath81

Try replacing allselected with all in your measure