Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
GFRO
Frequent Visitor

Hide value in a table that is filtered by another table

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 NameScore

Olivia

7
Nikola9
Caroline8

 

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 NameScore
Nikola9
Caroline8

 

Any idea how can I do it?

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

 

 

2 REPLIES 2
v-xinruzhu-msft
Community Support
Community Support

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

vxinruzhumsft_0-1698647886497.png

 

vxinruzhumsft_1-1698647895722.png

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
Super User
Super User

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.