Text in values section of Pivot Table

Hi this is view of my query


I have established many to one connections as mentioned above
In Manager lookup Column 1 is Manger Names(Text) One occurrence each name
in master 21-22, master ...... Manager name is repetitive occurence

If i establish connection between master and manager lookup, in my values section if i bring in the Column1 all the manager names appear
So i created a calculated measure like
=CONCATENATEX(values(Manager_lookup[Column1]),Manager_lookup[Column1],",")
Now i am not able to create connection for a measure


I need to insert names like this which falls in value section of pivot table

As I cannot share data i am not sharing the excel sheet

TIA