Hi All,
I'm working on creating a report for my company's benchmarking survey. We basically send out a similar survey to a bunch of different companies and create each company their own report to compare them to their peers. I've done this before using this article on dynamic grouping using DAX, but in this scenario, not every company within the survey is a considered a "peer" of the others.
For example, see my table below, but here is a summary:
Comp1 is a peer to 6 companies within the dataset
Comp2 is a peer to 7 companies within the dataset
Comp3 is a peer to 5 companies within the dataset
What is the best way to set up a new table / write measures to be able to compare my selected company to their peers, without including companies that aren't in their peer group?
Thanks so much!
Example table (factParticipant_PeerGroups) below:
| Selected | Company Peer |
| Comp1 | Comp5 |
| Comp1 | Comp7 |
| Comp1 | Comp8 |
| Comp1 | Comp9 |
| Comp1 | Comp11 |
| Comp1 | Comp15 |
| Comp2 | Comp5 |
| Comp2 | Comp9 |
| Comp2 | Comp11 |
| Comp2 | Comp15 |
| Comp2 | Comp16 |
| Comp2 | Comp17 |
| Comp2 | Comp18 |
| Comp3 | Comp1 |
| Comp3 | Comp4 |
| Comp3 | Comp6 |
| Comp3 | Comp13 |
| Comp3 | Comp15 |
