Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help with DAX

Hi,

 

I have a table like this below,

 

Loan IDAmount
11000
22000
33000

 

I need a new column called totalAmount which should be sum(Amount) against each LoanID like below

Loan IDAmounttotalAmount

1

10006000
220006000
330006000

 

totalAmount should be a calculated column not a measure.

 

Please Help

Ashish_Mathur 

 

Thanks,

Dharani

Need Help

2 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi,

     

    try this in a calculated column:  

    column = CALCULATE(sum('Table (2)'[Amount]),ALL('Table (2)'))
     
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Write this calculated column formula

    Column = SUM(Data[Amount])

    Hope this helps.