Forum Discussion

rmolinajr's avatar
rmolinajr
Frequent Visitor
8 years ago
Solved

Problem Filter and rankx

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.

Need Help

3 Replies

  • RMDNA's avatar
    RMDNA
    Solution Sage
    8 years ago

    rmolinajr,

     

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

    • rmolinajr's avatar
      rmolinajr
      Frequent Visitor
      8 years ago

      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.