How to display all rows meeting same criteria based on selected row

[fazikp2]

Hello everyone, I am trying to achieve something, which should be fairly simple, but I keep running into issues.

Lets say I have a data set, which looks like below:

Sales doc	Material ID	Billing doc
A	1	A1
B	1	A2
B	2	A3
D	2	A4
E	2	A5
F	2	A6
G	1	A7
H	1	A8
J	3	A9
K	1	A10

I would like to have two table visuals:

1.) First will have a list of Sales docs

2.) Second will have a list of Billing docs

What I want to achieve is, that if I select certain sales doc (let's say A), I will be able to see all the billing docs, which have the same material. E.g. in the example above, if I select Sales doc A, I would like to see Billing docs A1, A2, A7, A8 and A10 (as all of these contain material ID 1, which is also associated with Sales doc A).

Many thanks!

[parry2k · Accepted solution]

@fazikp2 solution is attached, check (Page3) and Material and Sales Docs table, ignore other tables in the model.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[fazikp2]

@parry2k : thanks Parry worked like a charm!

[parry2k]

@fazikp2 is this what you are looking for?

[fazikp2]

@parry2k That looks like exactly, what I am looking for 🙂 Would appreciate, if you could share the solution.