Forum Discussion

Chris2016's avatar
Chris2016
Resolver I
1 year ago
Solved

Selectedvalue with AND condition

Hello, I am trying to create a dynamic filter using the Selectedvalue function, but I'm not able to add multiple conditions, for example: _Goals = IF(SELECTEDVALUE(Table[Org])="X", 100, IF(SEL...
  • Selva-Salimi's avatar
    Selva-Salimi
    1 year ago

    Hi Chris2016 

     

    would you update your code as follows:

     

    _Goals = IF(SELECTEDVALUE(Table[Org])="X" && selectedvalue(Table[Category])="a", 100,
    IF(SELECTEDVALUE(Table[Org]) = "Y" && selectedvalue(Table[Category])="b", 95,
    IF(SELECTEDVALUE(Table[Org])="Z" && selectedvalue(Table[Category])="c", 90,
    80)))

     

    if not? please share more details of the error.

     

    If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly. 

Selva-Salimi's avatar
Selva-Salimi
Solution Sage
1 year ago

Hi Chris2016 

 

would you update your code as follows:

 

_Goals = IF(SELECTEDVALUE(Table[Org])="X" && selectedvalue(Table[Category])="a", 100,
IF(SELECTEDVALUE(Table[Org]) = "Y" && selectedvalue(Table[Category])="b", 95,
IF(SELECTEDVALUE(Table[Org])="Z" && selectedvalue(Table[Category])="c", 90,
80)))

 

if not? please share more details of the error.

 

If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly. 

  • Chris2016's avatar
    Chris2016
    Resolver I
    1 year ago

    Thank you, my bad, your formula was the exact one I was using and there was no error message, but the output was off due to an issue I was able to figure out in the meantime.
    Best regards!