Return count of common customers between countries having same IDs

[DARKLOARD]

Hello all!

Another doubt that I been going through.  I have a setup like below all in one table (with field ID & CNTRY) where in trying to return a count of the common customer ids between two or multiple countries. 

I filter on the CNTRY (always two country are selected to see the common customers) AE & SGP then I get 2 since only 2 IDs have have both AE & SGP tag, and the same for AE & KSA, since only 1 ID has both of them then only 1. 

Any clue how it could achieve this?

[danextian]

Hi @DARKLOARD ,

Can you please post a workable sample data - one that we can copy paste to Excel and  not an image?

[DARKLOARD · Accepted solution]

Hello!

I was able to resolve this by actually using a matrix instead of a card visual. 

Realized using a matrix would give much more results and info.

I shall close this thread now. 

Thanks again!

[DARKLOARD]

I shall do that soon, thanks!