Forum Discussion

Yaazh's avatar
Yaazh
New Member
1 year ago
Solved

SumX not working properly

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
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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.

1 Reply

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    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.