Unable to create a relation between text fields

Hi Anonymous ,

1. You relationship netween the tables "Sales by Day" and "Stelling_Master_data" on column "StellinID" is perfectly right.

2. In you .pbix file on "Page1" tab, 3rd table on the right, you have moved Stellin Id from both the tables but you get blank data for StellinID from "Stelling_Master_data" against the StellinIDs coming from "Sales by Day". The reason for this is, these StellinIds don't exist in your "Stelling_Master_data".

Unique StellinId count in "Stelling_Master_data" = 136

Unique StellinId count in "Sales by Day" = 16

There exist no common "StellinIds" in these two tables.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati