How do I pivot this data for a chord chart?

[Anonymous]

I'm trying to pivot some data so that it can feed into a chord chart but I'm not quite sure what to do. I'm trying to find each group that overlaps with other groups and how often they overlap. Ultimately counting the number of connections groups have, I think a chord chart is best to represent this.

Starting data looks like this:

User ID	Group
1	A
1	B
1	C
2	A
3	B
3	C

I want my data to look like this:

User ID	Group	Overlaps with
1	A	B
1	A	C
1	B	C
3	B	C

Note that it is only counting other groups. So A does not overlap with A, and B does not overlap with B. It also only counts 1 direction, so user 3 results in B overlapping with C but not also C overlapping with B.

[Greg_Deckler]

@Anonymous This strikes me as a permutations/combinations kind of thing. See if recipe 9 in Chapter 10 of my book, DAX Cookbook helps. gdeckler/DAXCookbook (github.com)