Solved: Show_If Statement - Page 2

Laurene_Haynesw · 08-19-2020 10:29 AM

In the app a user can register for a particular board. There are a total of 3 boards that they can register for. I have the following expression AND(CONTAINS([Board] = “C Note”, [Email Address]) = False, CONTAINS([Board] = “Monkey”, [Email Address]) = False, CONTAINS([Board] = “Monkey”, [Email Address]) = False) in the Show_If of the board assignment table. This, however, states: This formula is not evaluated in the context of a row, so column values are not available. How should I rewrite this formula to be in the proper context?

LeventK

You can use below expression in your ENUM’s Valid_if

LIST("C Note" , "Monkey" , "Le Dame Grande") - INTERSECT(("C Note" , "Monkey" , "Le Dame Grande"),SELECT(Board Assignment[Board],[Gifter].[Email Address] = USEREMAIL()))

View solution in original post