Calculated column with a sum

[Broeselchen]

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:

[serpiva64]

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 !

[Migasuke]

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

[Broeselchen]

Sorry, this didn't work.

[Migasuke]

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

[amitchandak · Accepted solution]

@Broeselchen , A new column

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