Count if with list

Hi , i have a column tipe LIST , where in each cell can be stored a list of value ( enum-list) that refers to another table

i need to count in that column how many times a certain value ([value-to-check]) from table2 is present

i have an expression like that
count(select( Table[column], in(table2[value-to-check],Table[column])))

but does not work

0 5 743
5 REPLIES 5
Top Labels in this Space