DAX question: Dynamically Grouping Peer Sets in Power BI

been_jannim — Wed, 31 Jan 2024 15:47:46 GMT

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

Re: DAX question: Dynamically Grouping Peer Sets in Power BI

Anonymous — Thu, 01 Feb 2024 08:35:42 GMT

Hi been_jannim ,

Please provide a screenshot of the test data and desired results so that I can answer your question as soon as possible.

Best Regards,
Adamk Kong

topic Re: DAX question: Dynamically Grouping Peer Sets in Power BI in DAX Commands and Tips

DAX question: Dynamically Grouping Peer Sets in Power BI

Re: DAX question: Dynamically Grouping Peer Sets in Power BI