Sum aggregation in each row & total for a column

[sb991986]

Hi,

In the below example, I would need total for a new column as 1300 but individual row as 800, 500 group by header id. Thank you

[DataInsights · Accepted solution]

@sb991986,

Try this measure:

Header ID Total = CALCULATE ( SUM ( Table1[Revenue] ), ALLEXCEPT ( Table1, Table1[Header ID] ))