Avoid filtering a table when selecting another

[jmateu88]

Hello,
I bring some very basic thing but I did not get to the solution.

I am trying to avoid the filters in a table when a value is selected.... in the other table.


We can see that in the first table, values 'C', 'D', 'E' are excluded and, we cannot see them. In the table on the right, we can see all values because there is nothing filtered.



After selecting in Team 'A', we see how the filter is excluding in the table of the right the values 'C', 'D' and 'E' which is not desired.



What I would like to obtain then I select the Team 'A' in the table of the left, is the result of the table on the right without filters.

I tryied with DAX but I did not have success.

Thank you in advance.

[vish_v]

Did you try Clicking the value in Table 2 + Ctrl when you have a value filtered/selected in Table 1?

[jmateu88]

Thank you @amitchandak  for your answer.

Unfortunately, editing the interactions is not the solution because we still need 'filtering' considering the team, which is the first level.

On the other hand, we do want to unfilter the second level.

So that is why this is very tricky. We want to filter but unfilter as well!.

Very thanks.

[amitchandak]

@jmateu88 , Seem a little bit tricky. see if this solution can help

Power BI Partial Interactions, Selectively pass filter across visuals - https://youtu.be/SFEKQEic_sk

[amitchandak]

@jmateu88 , Based on what I got, switch off the interaction between the slicer and the second table 

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4