I have a table where I add the fil that I see, with two colums
Table= Record
Colum1= Year
Colum2= Film
Now I would like to add a virtual column that print 0 if I see only one time the film or print 1 if I see more than one time.
I try it:
COUNT(SELECT(Record[Film], TRUE, FALSE))
COUNT(Record[Film])
but allways appear the number of rows I had recorded (200 rows), I only need two if [Film] appear in [Film] before… nothing more.
Thanks you so much
Solved! Go to Solution.
You have to make a comparison. That’s what the second argument of SELECT is for. Read through the SELECT article once more:
You have to make a comparison. That’s what the second argument of SELECT is for. Read through the SELECT article once more:
The rush is not good, I was so confused that I didn’t realize it, you were right, the condition to be met was missing. Thanks a lot.
User | Count |
---|---|
36 | |
32 | |
30 | |
18 | |
16 |