Data Model Issue ? Measure is being repeated once I add a column that is not linked to my Fact Table

[MarcoPazBI]

I got a data model with two Fact Tables, and both are grouped differently:

fExpenditures is grouped by columns [CIP], [Phase], [Award] and [Supplier]
fPhase Status is grouped by column [CIP] and [Phase] only (the Award and Supplier do not matter for when a Phase for a Project is going to start and finish).

I am trying to build a table like this:

As you can see, I have 3 lines for Design and 4 for Construction due phases having multiple Awards. My Phase Start and Phase Finish are acting accordingly on the example above.

When I try to replicate this in Power BI, I get a table with all Awards my data model got instead of only these 7 lines:

This is how my data model looks:

And this is the measure I created:

TEST Phase Start = 
VAR CurrentCIP = SELECTEDVALUE(dCIP[CIPKey])
VAR CurrentPhase = SELECTEDVALUE(dPhase[PhaseKey])
RETURN
CALCULATE(
    MIN('fPhase Dates'[Start]),
    'fPhase Dates'[CIPKey] = CurrentCIP,
    'fPhase Dates'[PhaseKey] = CurrentPhase
)

Any idea why this is ocurring and what would be the best way to fix it ?

Thanks

[olgad]

I would remove dPhase -expenditures and dcip-expenditures, connect dcip to phase dates and phase dates to expenditures. 

[MarcoPazBI]

If I do that, I will lose the ability to get my "Total Spent" from Expenditures, since there will be one connection between dPhase and dCIP to the Expenditure table, right ?

[olgad]

Can you ping me your report in private message  i will take a look how to connect them, may be it is easier like that