Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sum based on column (different grannularities)

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 ...
DAX
DAX Commands and Tips
DAX Measures
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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])))
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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?