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
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |