Forum Discussion
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(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!
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.
2 Replies
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.
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!
