Multiple Relationship Reporting

[Jodes007]

Hello I'm a newish Power BI user but a pretty advanced xls one 🙂 

We're strugling to put together a report to show specific relationships. 

The original data is 65K+ rows but i put some basic replicated data below. 

Tom is the main filter. 

We want Tom to be able to see what vehicle he took (easy). But also who others took the same vehicle type as him. 

Any help would be greatly appreciated. Thanks Jodi

[DataZoe · Accepted solution]

@Jodes007

I'm not sure it's the most elegant solution, but one way is to create a related table. The way I did it was:

1. Under Transform Data, right click on the table and choose "Reference" (this way it does not take up more space) and renamed the new table related to the table. Apply and close.

2. In the model, create a relationship between "How" in the tables, this will be many to many, but change it to an address, so the table filters related table.

3. Who data segmentation comes from Table, then you have a table with those values.

4. The second table is the data related to the table.

[Jodes007]

Genious solution!!! The only issue I had was when adding other details, it added in blanks which doubled the costs. But I just filtered out blanks to solve. Thank you so much.