DAX Help - Combine Groupby and Filter Functions

[pbakaric]

I need to FILTER my SUMX/GROUPBY function. I would like to combine these two DAX statements, however, I'm struggling to do so, please let me know if you have any suggestions:

Statement 1: 

SUMX(
GROUPBY('Demand Line Relation',

'Demand Line Relation'[Line],'Demand Line Relation'[Program],'Demand Line Relation'[Factory CapacityShifts],'Demand Line Relation'[FactoryCapacityHrs Per Shift]),
'Demand Line Relation'[Factory CapacityShifts]*Demand Line Relation'[FactoryCapacityHrs Per Shift]

)

Statement 2:

FILTER(
'Demand Line Relation',
'Demand Line Relation'[Factory]="HEC"

)

Preston

[pbakaric · Accepted solution]

I should have spent 5 more minutes on this, here is what I came up with:

SUMX(
FILTER(
GROUPBY(
'Demand Line Relation',
'Demand Line Relation'[Line],'Demand Line Relation'[Program],'Demand Line Relation'[Factory CapacityShifts],'Demand Line Relation'[FactoryCapacityHrs Per Shift],'Demand Line Relation'[Factory]
),
'Demand Line Relation'[Factory]="HEC"
),
'Demand Line Relation'[Factory CapacityShifts]*'Demand Line Relation'[FactoryCapacityHrs Per Shift]
)