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.
User | Count |
---|---|
17 | |
11 | |
5 | |
5 | |
5 |