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...
oh, sorry...can you try it if you only do single selection in the slcier:
SOLUTION =
VAR CurYear = SELECTEDVALUE('Period Map'[FY])
RETURN
CALCULATE(SUM(IPBI[Value]);IPBI[FY2]=CurYear)