Filter table based on multiple column values

[luapdoniv]

Hi,

Am looking for a solution to the below problem:

I've the following table, I need to find the connected students. A student is connected to others if they share the same class, trans or lab.

STID	CLASS	TRANS	LAB
101	5	Sbus	PHY
102	4	Sbus	CHE
103	5	Pvt	BIO
104	4	Pvt	PHY
105	6	Van	CHE
106	7	van	CHE
Desired Output
I'll have STID in a slicer to select
Based on the slicer selection the desired output
1. All students of the same class as the selected student
2. All students of the same transportation mode as the selected student
3. All students of the same lab as the selected student
Output as per above table would be, if 101 is selected:
101	5	Sbus	PHY
102	4	Sbus	CHE
103	5	Pvt	Bio
104	4	Pvt	PHY

Appreciate your thoughts.

[parry2k · Accepted solution]

@luapdoniv I provided a solution for a similar question, read the post here.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡

[luapdoniv]

Thank you @parry2k .
Was almost there, with the calculate table, but never thought it could passed into the var.
Instead was trying out with SELECTEDVALUES and that didn't help.

Your solution works like a charm. Much appreciated.
Is there anyway we can create a second table with all the filtered out ID's currently in the visual table?
Idea is to get them into a table dynamically on the student selection, so that we can create more conditional columns as required.

Any suggests.