Sum column values based on another column from second table

[epmck11]

Hello,

A bit new to Power BI here, so go easy on me.

I have two tables, table A and table B. Table A has a lot of customer numbers and their revenue for each transaction, while table B just has the distinct customer. I want to create a second column in Table B that has the sum of all the revenue from Table A for each of those customers. How can I do this?

Thanks

[Ashish_Mathur]

Hi,

Create a relationship from the Customer Name column of Table A (Revenue) to the Customer Name column of Table B (Customers).  Write this calculated column formula in Table B (Customers)

=SUMX(RELATEDTABLE(Revenue),[Revenue])

Hope this helps.

[Zubair_Muhammad]

Hi @epmck11

If the 2 tables are related to each other via customer column...then you can use this calculated column

Column =
CALCULATE ( SUM ( TableA[Revenue] ) )

[Zubair_Muhammad · Accepted solution]

@epmck11

If for some reason the tables do not have a relationship...you can use this column

Column =
CALCULATE (
    SUM ( TableA[Revenue] ),
    FILTER ( TableA, TableA[CustomerNo] = TableB[CustomerNo] )
)