Forum Discussion

Broeselchen's avatar
Broeselchen
Helper III
3 years ago
Solved

Calculated column with a sum

Hello, I need a calculated column with the total sales of each customer. I can't do it in a measure because I need it to eliminate the duplicates for the connection to an other table.

Example:

 

Need Help

5 Replies

  • Migasuke's avatar
    Migasuke
    Memorable Member
    3 years ago

    Hi Broeselchen ,
    If I understand well - you want to have new column with Total Sales, correct?
    If yes - please try following formula:

     

      • Migasuke's avatar
        Migasuke
        Memorable Member
        3 years ago

        Strange that it does not work for you, but I see that amitchandak has some alternative solution.
        Good luck with your project!

         

  • serpiva64's avatar
    serpiva64
    Solution Sage
    3 years ago

    Hi, 

    you can try this calculated column

    Column = var currclient = 'Table'[Column1]
    var result = CALCULATE(sumx('Table','Table'[Column2]), FILTER('Table', 'Table'[Column1]=currclient))
    return
    result
     

    If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !