How do I use IN or CONTAINS for Suggested_Values?

Hello! I'm trying to create an expression for a Suggested_Values formula that excludes blanks and only includes values that contain a ",". I tried the expression below but I can't seem to get it. Also tried using IN() but it told me that "The expression is valid but its result type 'Yes/No' is not one of the expected types: List".

SORT(Admin[NAME] - LIST("") + CONTAINS(LIST(","), FALSE))

0 2 105
2 REPLIES 2

Thanks very much, Marc, for showing me the SELECT documentation. From it I was able to create an expression that worked:

SORT(SELECT(Admin[NAME], (CONTAINS([NAME], ",")), FALSE))

Top Labels in this Space