combine and summarize the qty into one table

[pang22]

Hello,

I have two tables, how to use DAX to combine and summarize the qty into one table (third photo)?

[v-zhangti · Accepted solution]

Hi, @pang22 

You can try the following methods.

Method 1:

Measure = CALCULATE(SUM('Table 2'[Potential]),FILTER(ALL('Table 2'),[Factory]=SELECTEDVALUE('Table 1'[Factory])&&[Date]=SELECTEDVALUE('Table 1'[Date])))

Method 2:

New table:

New table = SUMMARIZE('Table 1','Table 1'[Factory],'Table 1'[Date],"Order OH",SUM('Table 1'[Order OH]),"Capacity",SUM('Table 1'[Capacity]))

Column = CALCULATE(SUM('Table 2'[Potential]),FILTER('Table 2',[Factory]=EARLIER('New table'[Factory])&&[Date]=EARLIER('New table'[Date])))

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

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