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

3 Replies

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