Hi Sam. Please could I get your eyes on this complex data model.
I am trying to get the top 2 tables (region and Territ) to be links in the Data Model.
What I’ve done is created a new table called Uniq ID (2nd screen shot) to get many ID, so I can get a 1-Many Rel.
By doing it this way it drills into the Employee Tables into main Fact table. Logically my model makes sense not sure why on page 2 my column fields are static on total sale.
Thanks in advance.
14.NorthWindDatabase.pbix (672.9 KB)