Get all ids that have the same attributes as the selected id

[louisk]

Hello,

i am struggling with the below.

I have a table with Ids, another one for each Id all the items purchased and a third one: Id and corresponding sales.

I would like to when selecting a certain Id to get all the ids and sales that have purchased one or more item as the selected Id.

[parry2k]

@louisk what you want the output to looks like? If one id has two items, do you want sales to be repeated twice.

[louisk]

and this is the correct relationship. @parry2k 

[louisk]

Updated:

So basically: I have 3 tables:

•  Ids:  containing: Id, name, DOB
• Purchases: Containing Id, Purchases
• Sales: containing: Id, Sales

What I would like to have is , when choosing a certain Id. for example Louis (Id1):

1. Display all Names that have purchased one or more items similar to Louis purchases. In this case it will display: Bouchra, Louis, Ralph, Ziad
2. Display all the names that have the same DOB as Louis. In this case it will display: Louis, Ziad
3. Display all the sales that are 30% less or more than Louis sales. It should display: Louis, Violet, Ariane, Bouchra, Elias

I have managed in a way to make point 1 and 2 work, by creating a temporary concatenated table which concatenates all attributes.

And hence, when selecting a certain Id, it will put it in a temp table : selected Ids, and lookup all its attributes.

Point 3 is not working properly. so the formula needs to be adjusted.

Also, I would like to have a slicer that will allow us to select: Yes / No instead of putting them in the filter pane. But teh slicer cannot take a measure. hence I don't know how to do it.

linke to pbix: https://drive.google.com/open?id=1M2Ma8Ph5NWYaCEQPWYKo-oBDxcVWao3y

[louisk]

Hello. This is is the output I would like to have.

so basicallu if I choose id=1, it needs to go to the table purchases and get me all Ids that have one or more items purchased same as Id 1 and then display them as unique values along with their sales