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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
SeanB004
Frequent Visitor

Referebce table fitering bank values

Hi All, 
I have 4 tables and I'm trying to filter for Who knows who for people with a certain job title.
However when I select the job title every goes blank as illustrated below. 

SeanB004_0-1691753930839.png
Here are the tables and their relationships

SeanB004_1-1691754085977.png

The Who knows table and the CompanyContacts table are connected to show who internally is connected to an outside contact. I need a table visual showing the company name, Location , and who is connected to who(from the Company Contacts to the Employees table. I need to be able to filter by the job title . i.e show all Accountants(from the Employees table) and the result should show all Contacts(from Company Contacts) affiliated with an accountant.
Data without filter applied:

SeanB004_2-1691754527300.png

 





 

0 REPLIES 0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.