SUM(table1[Y]) IF ( table1[X] IN table2[X] )

[jdevalk]

Hi,

I have 2 tables and both have column X but table1 has more X-values than table 2 has.

Now I need to SUM table1[Y] IF table1[X] IN table2[X].

Can anyone help with the DAX formula?

[v-chenwuz-msft · Accepted solution]

Hi @jdevalk,

Measure to do that.

CALCULATE (
    SUM ( Table1[y] ),
    FILTER ( Table1, [X] IN VALUES ( 'Table2'[X] ) )
)

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SpartaBI]

@jdevalk if you create a realtionship between the 2 tables and plot it on a visual in Power BI it will happen automatically. If you don't succeed maybe share sample data and I will share a PBIX with the solution.