https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Referebce-table-fitering-bank-values/m-p/3376270#M157575 <P>Hi All,&nbsp;<BR />I have 4 tables and I'm trying to filter for Who knows who for people with a certain job title.<BR />However when I select the job title every goes blank as illustrated below.&nbsp;<BR /><BR /></P><P><img /><BR />Here are the tables and their relationships</P><P><img /></P><P>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.<BR />Data without filter applied:</P><P><img /></P><P>&nbsp;</P><P><BR /><BR /><BR /><BR /></P><P>&nbsp;</P> Fri, 11 Aug 2023 11:50:20 GMT SeanB004 2023-08-11T11:50:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Referebce-table-fitering-bank-values/m-p/3376270#M157575 <P>Hi All,&nbsp;<BR />I have 4 tables and I'm trying to filter for Who knows who for people with a certain job title.<BR />However when I select the job title every goes blank as illustrated below.&nbsp;<BR /><BR /></P><P><img /><BR />Here are the tables and their relationships</P><P><img /></P><P>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.<BR />Data without filter applied:</P><P><img /></P><P>&nbsp;</P><P><BR /><BR /><BR /><BR /></P><P>&nbsp;</P> Fri, 11 Aug 2023 11:50:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Referebce-table-fitering-bank-values/m-p/3376270#M157575 SeanB004 2023-08-11T11:50:20Z