Group ID Status Product
AA12 1 B
AA12 2 A
BB23 1 A
BB23 1 A
CC34 2 B
CC34 2 B
My data looks like the above and what I am trying to do is filter it such that I only get Group IDs where the status is the same for both products. In other words an output of rows with a status of 2
CC34 2 B
CC34 2 B
The main issue I'm having is trying make a filter that will remove the group IDs like the first two rows
I haven't tried it, but would something like
count(distinct ([Group ID] || [Status])) > 1
work for you?