Filtering ConcatenateX measure from many side of the table in the many-to-one relationship

[DataNinja777]

Hi Experts,

I am trying to filter the ConcatenateX measure output from the related table of many side of the relationship in the many-to-one relationship.  The ConcatenateX formula calculated the name of the employee and the tenure, and the Lease table has many to one relationship with the Employee table where ConcatenateX formula resides.  

When I try to filter the information of the ConcatenateX formula using the Lease asset #, the ConcatenateX formula is yeilding the list of all the employees without filtering by the employee numbers which has many-to-one relationship with the employee table.  I am assuming that this is due to the fact that relationship only flow in one direction from one to many side, and not the other way round. I am using Excel Power Pivot and do not have option of activating bi-directional relationship.  I remember that I used relatedtable to solve this kind of issue in the past, but I'd greatly appreciate it if someone can remind me how to fix the formula below.  

Thanks a lot!

[DataNinja777 · Accepted solution]

Crossfilter dax function combined with Calculate solved this issue.