Problem Filter and rankx

[rmolinajr]

Hi

I am having problem in rank, when I do a search in slicer the rank changes everything, I am using this dax code to create the rank:

RANK =
RANKX (
     ALLSELECTED (table [Name]);
     [VALUE]
)

In slicer search I am using a date and the name.

When I select the name, it automatically changes the whole rank, but I would like to appear the rank as it was before.

[v-chuncz-msft · Accepted solution]

@rmolinajr,

It seems that you may use ALL Function instead.

[RMDNA]

@rmolinajr,

Just to clarify: you want the slicer to filter the rest of the table, except keep the rank static?

[rmolinajr]

That's right, I need when I choose in the slice filter name, it appears in the table that person that chooses, but with the rank that was appearing.
Without choosing a name the table will appear all names and ranks of each one, when I choose a name in the slicer filter in the table appears the name, but the rank changes, did not want it to change.