Forum Discussion

sneevand's avatar
sneevand
Frequent Visitor
5 years ago
Solved

Cumulative total by category -Measure

 

Raw data 

Dateamountproduct
01-01-202010Product1
01-02-202012Product2
01-03-202010Product1
01-04-202013Product2
01-05-202015product2
01-06-202010product1
 70 

 

Expected data:

Dateamountproducttotalbyproduct
01-01-202010Product130
01-02-202012Product240
01-03-202010Product130
01-04-202013Product240
01-05-202015product240
01-06-202010product130
 70  

1 Reply

  • Does this work for your context?

     

     

    Sum by Product: = 
    CALCULATE(
        SUM('Table'[amount]),
        ALLEXCEPT('Table', 'Table'[product])
    )
    
    //Removes filter context from the table except for product

     

     

    Result:

     

     

    https://docs.microsoft.com/en-us/dax/allexcept-function-dax

     

    If this works for you then please select as Answer.  All likes and Kudos appreciated.