Forum Discussion
Solved
Get SUM per customer
Hello, this is a massively beginner question bu I wasn't able to find a solution yet. I need to create a column, where I would have the total revenue for every customer. So it would repeat per cu...
You can create Calculated column or measure using below DAX code:
Category Revenue = CALCULATE(SUM(CustTable[Revenue]),ALLEXCEPT('CustTable','CustTable'[Customer]))
Calculated Column will give following output:
Measure will give following output:
Please mark my solution as Accepted if it helped you.
You can create Calculated column or measure using below DAX code:
Category Revenue = CALCULATE(SUM(CustTable[Revenue]),ALLEXCEPT('CustTable','CustTable'[Customer]))
Calculated Column will give following output:
Measure will give following output:
Please mark my solution as Accepted if it helped you.
