Forum Discussion

Alxnder's avatar
Alxnder
Frequent Visitor
2 years ago
Solved

sum with multiple criteria

Hello, any help would be greatly apprecaited, this should help create other measures.    Here is the sample data: I need to be able to sum  based on the following creteria.        ...
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    Alxnder Try:

    Measure = 
  SUMX(
    FILTER( 'Table', [Variety] = "Navel" && [Grade] = "Fancy" && [Export Market] = "Domestic" && [age] > 10 ),
    [Qty]
  )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

Alxnder Try:

Measure = 
  SUMX(
    FILTER( 'Table', [Variety] = "Navel" && [Grade] = "Fancy" && [Export Market] = "Domestic" && [age] > 10 ),
    [Qty]
  )
  • Alxnder's avatar
    Alxnder
    Frequent Visitor
    2 years ago

    Greg_Deckler --- perfection, worked like a charm. Much appreciated!!