How many times does a string appear in a list?

[GabrielAra]

What would be the expression alternatives to use instead of COUNT(SELECT(Table1[phones],[phones]=[_THISROW].[phoneContact])>=2 since it is not possible to compare a list with a number?

note: [phones] is a virtual column of type LIST that contains the contact numbers of another table, example: LIST(Table1[phone1], Table1[phone2], Table1[phone3])

The goal here would be to count how many times [phoneContact] of the current row appears in table1[phones] and if the value is equal to or greater than 2 causes the action not to be performed.

[RBTAndrade]

Hi @GabrielAra , try COUNT(SELECT(Table1[phones], IN([_THISROW].[phoneContact],[phones]))>=2

[JeeHill]

Use this:

COUNT(FILTER("Table1", IN([_THISROW].[phoneContact], [phones]))) >= 2

It checks if the number appears in [phones] at least twice, no issues. 😉

Jee