Preventing filter in filter pane to not propagate down the relationship?

[afaro]

If I have two tables T1 and T2: 

T1

T1 Item	Child	Active
A	B	Yes
A	C	No
D	E	No

T2

T2 Item

B

C

D

Child of T1 is connected to Item in T2. 

I have two visuals V1 and V2 based off T1 and T2 respectively:
V1 has an extra filter in the filter pane as Active = yes. 

V1 Item

A

Now, 

V2 has is same as T2.

Now, when I click on row with Item A in V1, it would show me this in V2:

V2 Item

B

However, I want to know if there is a way for the normal v1-child->v2-item relationship to propagate and be seen but the active filter put on v1 (in filter pane) is not propagated to v2? 

The output on clicking row in V1 (with v1 item A) would look like this in V2: 

V2 Item

B

C

[Anonymous · Accepted solution]

Hi @afaro ,

Since the child items of T1 are connected to items in T2, selecting row A will filter the data in V2 based on the B in child. You can solve the problem by creating a calculation table that has no relationship with the original table.

1. Create a calculation table.

Table 3 =
SELECTCOLUMNS('Table 2','Table 2'[T2 Item])

2. Create the MEASUREMENT.

SelectedItems =
VAR _column =
SELECTCOLUMNS (
FILTER ( ALL ( 'Table' ), 'Table'[T1 Item] = MAX ( 'Table'[T1 Item] ) ),
"1", 'Table'[Child]
)
RETURN
IF ( MAX ( 'Table 3'[Table 2_T2 Item] ) IN _column, 1, 0 )

3. Put SelectedItems into the filter of table 3 and filter the data with value 1.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[afaro]

Works perfectly!