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(
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

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

     

1 Reply

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