Selectedvalue with AND condition

[Chris2016]

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(SELECTEDVALUE(Table[Org]) = "Y", 95,
IF(SELECTEDVALUE(Table[Org])="Z", 90,
80)))

What I would like to add is another condition for the selectedvalue, such as:

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

Is there any way to do that?

Many thanks!

[Selva-Salimi · Accepted solution]

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]

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!