SumX not working properly

[Yaazh]

Formula used is 

TotalInvoicedRow =

CALCULATE(

    SUM('AE Dataset'[Invoiced]),

    ALLEXCEPT('AE Dataset', 'AE Dataset'[Contact]) but out put is not the same as "Sum Of Invoiced" Column, can you pls help

[rajendraongole1 · Accepted solution]

Hi @Yaazh - It seems like the TotalInvoicedRow calculation is returning the sum of the Invoiced values without respecting the individual row-level context, causing it to show an aggregated total for each Contact rather than the same values as the "Sum of Invoiced" column.

TotalInvoicedRow = SUM('AE Dataset'[Invoiced])

This will sum the Invoiced values for each row individually, matching the "Sum of Invoiced" column.