Measure Totals are Wrong with IF condition measure

[PMnooBI]

Proposal LC is  the Budget and is a column 

Labor Spent is a measure which is ( Hours * hourly rate)

Contractors is a column but no values here 

Total Spent LC is a measure of (Labor Spent + Contractors)

Remaining Labor is a measure( Proposal LC - Total Spent LC)

Billed LC is a measure 

Billed LC = IF(CALCULATE(SUM(TaskBaselines[TaskBaselineCost])) > [Total Spent LC], [Total Spent LC], CALCULATE(SUM(TaskBaselines[TaskBaselineCost])))

taskbaselinecost is Proposal LC

Billed LC should be 9000 less but I think the dax is applying the measure to totals as well.

I want the totals to add every value in the Billed LC column 

HOW DO I RESOLVE THIS? 

@MFelix@Greg_Deckler@tamerj1@amitchandak@Arul@Ahmedx

[tamerj1 · Accepted solution]

Hi @PMnooBI 
Please try

Billed LC =
SUMX (
    VALUES ( TaskBaselines[Phase.1] ),
    VAR TaskBaselineCost =
        CALCULATE ( SUM ( TaskBaselines[TaskBaselineCost] ) )
    VAR TotalSpentLC = [Total Spent LC]
    RETURN
        IF ( TaskBaselineCost > TotalSpentLC, TotalSpentLC, CTaskBaselineCost )
)

[PMnooBI]

It worked!

Thanks