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))
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))
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |