Tableau Filtering on ocurence of a String

Question

I have a Field in my Column that is filed with a String that can have a multiple occurence of the same word. Now what i want to do is to Filter this Column so that a certain Word mus occure and that only the rows show up where another word don't ocure more than one time. Here is what i get so far:

CONTAINS([Column1], "Santiego") AND COUNT(CONTAINS([Column1], "25")) < 2

The error tells me I canot mix Agregat and Non Agregat Arguments.

Is there any possibility to do this kind of filtering?

Answer 1

I found a solution,

In the Filter function You have to use just the Column you need and Filter with this Formula:

COUNT(CONTAINS([Column1], "25")) < 2

After that you just create a new calculation that you put in the Filter, the calculation uses then this Formula:

CONTAINS([Column1], "Santiego")