Forum Discussion

mbidelski's avatar
mbidelski
Helper I
6 years ago

Rank filtered values

Hello, Im trying to create a set of charts like this:   The year slicer filters data for the left chart. The right chart uses a copy of years column and measure ignoring the year filter fro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi mbidelski  it is because ALL removes all the filters, you can use ALLSELECTED

mbidelski's avatar
mbidelski
Helper I
6 years ago

With ALLSELECTED only the values from the filtered year get ranked. The rest is ranked at the bottom (last position in the ranking). The chart only shows one year. Screen: https://imgur.com/koOUhiF

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi mbidelski, can't see your image, use ALL or ALLSELECTED depends on how you want to RANK, RANKX can compare different values with the 3rd argument as well. You can get your slicer year into your measure, so it is dynamtic.

     

    SOLUTION = CALCULATE(SUM(IPBI[Value]);IPBI[FY2]=SELECTEDVALUE(yourSlicerYear))

    Rank = RANKX(ALL(IPBI);[SOLUTION];;DESC;Dense)

    • mbidelski's avatar
      mbidelski
      Helper I
      6 years ago

      Anonymous thank you for your help. Here's what happens with ALLSELECTED, the Rank function ignores everything thats filtered out, I need all years to get the same rank:

       

      SELECTEDVALUE didnt work either, maybe I got the syntax wrong?