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
  • amitchandak's avatar
    amitchandak
    3 years ago

    Broeselchen , A new column

     

    Sumx(filter(Table, [Customer] = earlier([Customer]) ), [Sales])

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 !