Hide value in a table that is filtered by another table

[GFRO]

Let's call them Table 1 and Table 2.

Table 1 has a list of team members. Both columns are pulling data from a table called Gratuity.

Full Name	Score
Olivia	7
Nikola	9
Caroline	8

Table 2 lists team members received from another source table called Hosts. Both tables are connected by an ID.

When I click on 'Olivia' in Table 1 I want to hide her name for Table 2.

Full Name	Score
Nikola	9
Caroline	8

Any idea how can I do it?

I tried to use SELECTEDVALUE but I don't think I did it correctly.

[v-xinruzhu-msft]

Hi @GFRO 

You can consider to remove the relationship, then you can create a measure

Measure = CALCULATE(SUM('Table (2)'[Score]),FILTER('Table (2)',SELECTEDVALUE('Table (2)'[Full Name])<>SELECTEDVALUE('Table'[Full Name])))

Output

Best Regards!

Yolo Zhu

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

[lbendlin]

These tables cannot be connected. Instead, use measures to calculate the visibility of row or row groups in the second table depending on the "selection"  the use made in the first table.