Summing of all projects instead of per project

[FrancisGhao]

Hi all,

I have 2 tables.

Table 1: 1 with column projectname and column with budgeted hours.

Table 2: Activties.

Relationship has been setup in model.

When I drop the budgeted hours in the matrix, it sums up all the budgeted hours of all projects and shows each project the total. 

I was expecting PowerBI to show each project and its budgeted hours. 

Here is the link to file.  Is this related with formula ignoring row-context or another problem? What would be the dax solution and is there any link to documentation regarding this subject or similar samples that I could learn from? 

[SanKing · Accepted solution]

Hi @FrancisGhao ,

Change field in matrix 'ProjectName' to have this field from 'ProjectList' Table.

[FrancisGhao]

Thank you that solved it.
I still have the grasp the logic. Is it general rule always picking the field from the "one" table of the "one-to-many" when creating report?