cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdevalk
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION
v-chenwuz-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-chenwuz-msft
Community Support
Community Support

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
Community Champion
Community Champion

@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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.