Solved: Select expression with CONTAIN - Page 2

Hyman_van_Zyl · 05-15-2019 02:54 AM

Hey Guys,
I want to select a category based on if a key word in present in the description of a transaction. I added a key word column to the category table. I am trying to use this expression but it does not work. If I change the expression to a LIST it lists all the categories.
What am I missing?Thanks
ANY(SELECT(Categories[Category],CONTAINS([Description],[Key Word])))

Steve

Ah, try this:

ANY(
  SELECT(
    Categories[Category],
    AND(
      ISNOTBLANK([Key Word]),
      CONTAINS([_THISROW].[Description],[Key Word])
    )
  )
)

View solution in original post