Populate table visual through a field not connected in the data model

Hi,Quenril 

If you want to keep the original slicer Settings, but want it to affect another column, in addition to my new table as a slicer, the only way I can provide now is to break the relationship between the two tables or directly change the inactive relationship to the active relationship, because the functionality of the slicer always can only filter the column that created the slicer or the column that has a relationship with his table, as I did before The table affected by the slicer is replaced with another table, and after obtaining the slicer value with the degree value, another column of the original table is filtered.

1.Here are my updated measure based on the data you provided, disconnecting all relationships:

REFERED = 
VAR CC=SELECTEDVALUE('consultant lookup'[Consultant Name])
RETURN
IF(ISFILTERED('consultant lookup'[Consultant Name]),
CALCULATE(MAX('live job'[Referred by]),FILTER('live job','live job'[Referred by]=CC)),MAX('live job'[Referred by]))

2.Of course, you can achieve the same result if you choose to change the inactive relationship to the active one as shown below:

3.Here's my final result, which I hope meets your requirements.

4.Here is the relevant documentation:

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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