Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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)