Bidirectional filtering in the same table...

[pedros123]

Hello guys,

I have a table which has students that are enrolled in more than one major which are called here "Descr2, Descr3, Descr4".

People who have "Descr4" are the ones who have a third major.

What i'm struggling with is that i want to know for example, in the major "BA Sport Sciences" what are the other majors that people are enrolled to.

Example in the first row: if i select "Liscence Gestion des Affaires" in  visual1, visual2 will display "Liscence EPS".

But if i select "liscence EPS" in visual1, visual2 won't display "Liscence Gestion des Affaires".

Any help would be appreciated, thanks!!

[v-jayw-msft]

Hi @pedros123 ,

I think it can be done with DAX but we need more information. Can you show us what are your visual1 and visual2 look like and what's your expected result.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.