Joining Existing Data in Power Bi with Excel file

[corporate_buddy]

My issue is that I have data coming from SQL serber which is already in Power bi. I created a spreadsheet with some metrics and want to join that to the data. The data has common field Cusotmer ID but that's all. When I try to join through relatiosnhips the filters for other fields do not work for example district or item etc. I have tried to also Merge queries but it refuses to find all similar Customer ID. Any thoughts on how I can solve this? 

[Greg_Deckler]

@corporate_buddy Sample data would help tremendously. Hard to know what is wrong without seeing things. 

[corporate_buddy]

So this is a picture of the relationships tab. 
Customer, sales item are all from our SQL database. I am trying to join table Avg of bins to them with customer ID but running into an issue.