Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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_...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

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.