cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlfonsoHerrero New Member
New Member

Power BI. Slicing selected value

 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!!!!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Power BI. Slicing selected value

@AlfonsoHerrero ,

 

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.

1 REPLY 1
Community Support Team
Community Support Team

Re: Power BI. Slicing selected value

@AlfonsoHerrero ,

 

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.