Circular filtering in Power B - NEED a HERO for this.

[Asina]

I have 2 tables called Table A and Table B. 

Table A has a Column with names that Table B uses a calculation on and filters the connected values. 

TABLE A

Keys	Main
55	A1
44	A1
65	A3
55	A3
55	A2
88	A2

Table B

Main	Connected to
A1	A2
A1	A3
A3	A2
A3	A1
A2	A1
A2	A3

Here is what I want from the above.

I want to be able to Filter a value in Table A, lets say A1 and get A2 and A3, which I do at the moment.

Then I want to click on lets say A2 of the filtered A1 and it will show me A1 and A3, which also works due to circular filtering.

However, Since I have attached fotos based on A1 to Ax, when I press 1 of the filtered values I get the picture related to the last filtered value not the rest.

So when i put different slicers I only get the PBI to show me the picture filter for 1 of the slicers not all....

here is how the connection works at the moment: 

[Syndicate_Admin]

There @Syndicate_Admin ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _selectBPrincipal=SELECTEDVALUE('Cuador B'[Principal])
var _selectBConectado=SELECTEDVALUE('Cuador B'[Conectado a])
var _column1=SELECTCOLUMNS(FILTER(ALL('Cuador B'),'Cuador B'[Conectado a]=_selectBConectado),"1",[Principal])
return
IF(
    MAX('Cuador A'[Principal]) in _column1,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

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

[Asina]

Unfortunately, it does not do anything different in what the casual filter does.

Maybe I have not explained the problem correctly.

I have a Table A, which has a Main column, where a table of pictures are connected to (for each row there is a picture) . The picture table has a similar Main column which is why I can connect it to the Table A.

Table B is a calculation of Table A, because the Table A Main columns has a subcolumn, where each row in Main can have connection to several of the subcolumn rows, which in the end has same names as the Main.

Its like a dot where several lines are connected to, But the dot itself can only belong to one of the lines, thats why the rest of the lines are neighbor to the dot-connected line. (its hard to explain).

Now, I have a code that gets me the dot-connected-lines neighbors. The neighbors have similarly connection to other lines, lets called them neighbors neighbor. 

I want to be able to click on main dot-connected-line and get all the following connections..

which when I click any of them..the picture table shows me the picture for.