Forum Discussion
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...
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)
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?