Calculated Column Filter not working

[CarlsBerg999]

Hi,

I'm trying to calculate the total value of a production lot. The equivalent from excel would be SUMPRODUCT. For example, the result should be 107,8 for all rows in LOT 222. However, it appears my calculation is still filtering on row level even though I included "ALL" to the calculated column. What am i doing wrong here?

Lot Production Cost = CALCULATE(SUMX('In-House Production Costs v2','In-House Production Costs v2'[Material Billable Quantity per Lot]*'In-House Production Costs v2'[Billable Value Base]),ALL('In-House Production Costs v2'[Production Lot ID]),

'In-House Production Costs v2'[Production Lot ID]=EARLIER('In-House Production Costs v2'[Production Lot ID]))

[jdbuchanan71 · Accepted solution]

@CarlsBerg999 

Try removing all the filters except the one on [Production Lot ID]

Lot Production Cost =
CALCULATE (
    SUMX (
        'In-House Production Costs v2',
        'In-House Production Costs v2'[Material Billable Quantity per Lot] * 'In-House Production Costs v2'[Billable Value Base]
    ),
    ALLEXCEPT (
        'In-House Production Costs v2',
        'In-House Production Costs v2'[Production Lot ID]
    )
)