Forum Discussion

mbidelski's avatar
mbidelski
Icon for Helper I rankHelper 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
mbidelski's avatar
mbidelski
Icon for Helper I rankHelper 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)