Get SUM per customer

[bundipapa]

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 customer. In excel it would be a simple SUMIF(Revenue, Customer=Customer in the given line).

However  as a total beginner, I'm unable to recreate this as a column in Power BI.

Any help is appreciated.

[Dhairya · Accepted solution]

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.

[bundipapa]

Thank you

[Dhairya]

You're welcome