Hi all, is there a way to combine an AND stat...

[elan_Bailey]

Hi all, is there a way to combine an AND statement and a SELECT in one expression?

I’m trying to create a slice based on these two expressions: SELECT(Intentions[Plan ID], [_THISROW].[Life Domain]=[Life Domain]) NOT([Status] =“Realized”)

When I try to combine them with an AND I get an error. Here’s what I’ve tried so far: Version 1: AND(SELECT(Intentions[Plan ID], [_THISROW].[Life Domain]=[Life Domain]), NOT([Status] ="Realized”))

Version 2: AND(NOT([Status] =“Realized”), SELECT(Intentions[Plan ID], [_THISROW].[Life Domain]=[Life Domain])

Any ideas?

e