Need help creating a data model!

When you look at your Contract column in Data View do it show that the # of distinct values is same as # of rows?  If not, you can do the following in the query editor on that column:

1. Remove blank rows

2. Remove duplicates

3. Also make sure there are not two values that are the same but differ in upper vs lower case (M is case sensitive but DAX/relationships are not.  If so, you can apply UPPERCASE or lowercase to that column before your Remove Duplicates step to address that.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat