Sum based on column (different grannularities)

[Anonymous]

Doc number	Date	Customer	Sales	TOTAL SALES per customer
1	01/01/2021	Microsoft	100	600
2	02/01/2021	Apple	50	50
3	02/01/2021	Microsoft	200	600
4	03/01/2021	Microsoft	300	600

Hi all,

I need help to create a dax formula for the last column.

It takes the sum of all Sales in the column, based on the Customer Name.

Example: for customer "microsoft" it does 100 + 200 + 300 = 600.

My "sales" column is in reality also already a measure.

Many thanks in advance for your time.

[amitchandak]

@Anonymous , Try a new measure like

calculate(sum(Table[Sales]), allexcept(Table, Table[Customer]))

or

calculate(sum(Table[Sales]), filetr(allselected(Table), Table[Customer] = max(Table[Customer])))

[Anonymous]

Hi, 

thanks for your reply.

I tried both but they did not work. Both return me the same values as in the sample data column "sales"

This is what I tried: (note: [(€) Turnover CP] is a measure that performs a formula for sales already (it calculates with discounts and quantities and several prices))

First option: calculate([(€) Turnover CP]; allexcept(Customer;Customer[Customer]))

Second option: 

calculate([(€) Turnover CP]; filter(allselected(Customer); Customer[Customer] = max(Customer[Customer])))

[amitchandak]

@Anonymous , Please find the attached file after the signature. I created same formula

[Anonymous]

Hi,

It works indeed as desired, but I have a memory issue if I perform it on my full dataset :(.

Would you have another idea?