Forum Discussion

pbakaric's avatar
pbakaric
Frequent Visitor
9 years ago
Solved

DAX Help - Combine Groupby and Filter Functions

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(...
Need Help
Tips and Tricks
  • pbakaric's avatar
    pbakaric
    9 years ago

    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]
    )

     

pbakaric's avatar
pbakaric
Frequent Visitor
9 years ago

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]
)