Power BI. Slicing selected value

[Anonymous]

 am doing a chart where I have to show the SCORE of the last four ranks from either the selected rank or the max rank (if none are selected).

The measure I am trying to use is as follows:

Score_IECO_ALL_ALL =

     VAR X = SELECTEDVALUE('SCORE'[Ranking];MAX('SCORE'[Ranking]))

RETURN

     CALCULATE([Score_IECO];FILTER('SCORE';'SCORE[Ranking]<=X;'SCORE[Ranking]>=X-4))

But it returns to me all values (no filter). Please help.

Thanks!!!!

[v-yuta-msft · Accepted solution]

@Anonymous ,

Modify your measure like below and check if it can work:

Score_IECO_ALL_ALL =
VAR X =
    SELECTEDVALUE ( 'SCORE'[Ranking]; MAX ( 'SCORE'[Ranking] ) )
RETURN
    CALCULATE (
        [Score_IECO];
        FILTER ( 'SCORE'; 'SCORE'[Ranking] <= X && 'SCORE'[Ranking] >= X - 4 )
    )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.