How to add a calculated Column with SumIf function that takes values into account of another table

Question

Hello,&nbsp;I'm new to PowerBI and I'm having a hard time to expand a table "Leverancier - Total Ordering" with a new column where every row/cell is a SUMIF of the column "Ordering" of another table "REVEX-TOTAAL". The cell/row of this new column is the SUM of all the orders of a certain supplier. The supplier is been set up as "Leverancier" (column) in&nbsp;tables "Leverancier - Total Ordering" &amp;&nbsp;"REVEX-TOTAAL".&nbsp;I want to use this as a next step for something else.&nbsp;Can someone help me please? 🙂&nbsp;Overview Tables&nbsp;Table "Leverancier" where I want to add a SUMIF from the column "Ordering" of the table "REVEX-TOTAAL" if the "Leverancier" matches&nbsp;Part of Table "REVEX-TOTAAL"&nbsp;&nbsp;

anonymous · Accepted Answer

HI&nbsp;Jelse,
I'd like to suggest you use sumx function with current table value as condition to filter and aggregate another table records.
formula =
SUMX (
    FILTER (
        'REVEX-TOTAAL',
        'REVEX-TOTAAL'[Leverancier]
            = EARLIER ( 'Leverancier - Total Ordering'[Leverancier] )
    ),
    [Ordering]
)
SUMX function (DAX) - DAX | Microsoft Learn
EARLIER, EARLIEST – DAX Guide - SQLBI
Regards,
Xiaoxin Sheng

Forum Discussion

How to add a calculated Column with SumIf function that takes values into account of another table

2 Replies

Related content

calculate with max() function

SUM function doing wrongly calculation

Community account support

calculate function

Using TREATAS DAX function in calculated columns