Relation issue

Hi nbaudry 

As tested, i make some transformations in your model.

( You could downlaod my pbix file, in Edit queries, open Advanced editor, you can see the M code and paste it in your file,

Or you can click on each step and find details for steps )

Steps below:

   In Edit queries:

1. in "capacity" table,

  1.1  merge queries from "project" table based on column "Name" (Capacity table), column "Project manager" ("project" table),

         when expanding, only select "id" to show on the "capacity" table.

  1.2 select "Name", "date", "Project.ID", merge columns, then we get a new column "name-date-id-capacity".

2. in "load" table, select "Project Manager", "date", "Project ID", merge columns, then we get a new column "name-date-id-load".

3. merge new queries from "capacity" table and  "load" table, based on "name-date-id-capacity" and "name-date-id-load",

    select "full outer" for "Join kind",  when expanding, only select "Load (days)" to show on this new table.

4. right click on the "capacity" table and  "load" table, uncheck "enable load", 

    in this case, the two tables won't show on the "Data Model" view, so to save the data size and improve performance for reports.

    Cloase&&apply.

In Relationship view.

Finally,