I've downloaded the data and played with this a bit but haven't been able to get things to work the way you want. I also assumed there would have to be some sort of equal function + count distinct. I have a feeling the issue is with getting the data sources to play nice. Either way, if you've found a solution then please share! Otherwise, I would Submit a case to our support team.