AND IF in conditional column

'Wrong totals' is usually an effect of misunderstanding what the total row contains: it is not the total of the rows above, it's the result of the same measure in a different context, in this case without the row identifiers filtered.
So your measure is not a simple SUM, but you do want the total to add up. The solution in this case is to force DAX to calculate results on a row-by-row basis, you can do this with SUMX. Trying to mimic your model:

SUMX(VALUES(ProjectTable[Complete Project Detail]), [Your original measure])

or, if Complete Project Detail is unique in the Project table:

SUMX(Project, [Your original measure])

If you don' want to call another measure [Your original measure] but want to include the logic in this measure directly, it's probably safest to wrap it in CALCULATE:

SUMX(
    VALUES(ProjectTable[Complete Project Detail]),
    CALCULATE(<Your original formula goes here>)
)