how to create formula for new amount column based on account

[PTSS]

Site   Type    Period              Account       Amount
BD1   ANF    2022-09-15     Thujan          4
BD1   ANF    2022-09-16     Thujan          4
BD1   ANF    2022-09-15     Factor           0.3
BD1   ANF    2022-09-16     Factor           0.3
BD1   ANF    2022-09-15     Slippery        1.2
BD1   ANF    2022-09-16     Slippery        1.2

i want to create a new column with sum of values ​​by account,

I've tried this formula but it doesn't work

Amount THujan = CALCULATE([Amount], SS_Account="Thujan")

is there any other way?

[MahyarTF · Accepted solution]

Hi,

you could use the below code for creating the column :

NewAmount = CALCULATE(sum(Sheet56[amount]), all(Sheet56), Sheet56[Account] = EARLIER(Sheet56[Account]))

Appreciate your Kudos and please mark it as a solution if it helps you 

[FreemanZ]

try to add a new column with the code below:

 AmountSum =

VAR CurrentAccount = TableName[Account]

RETURN

    CALCULATE(

        SUM(TableName[Amount]),

        TableName[Account] = CurrentAccount,

        ALL()

)

I tried and it worked like this:

[AbbasG · Accepted solution]

@PTSS I think you are missing "SUM" here. Hope it Help's

[MahyarTF · Accepted solution]

Hi,

you could use the below code for creating the column :

NewAmount = CALCULATE(sum(Sheet56[amount]), all(Sheet56), Sheet56[Account] = EARLIER(Sheet56[Account]))

Appreciate your Kudos and please mark it as a solution if it helps you