SUM WITH FILTERS

[akpresta]

Hello, I need help I have an error on this measurement how can I do ? I know it comes from having 2 conditions at the same time it doesn't work with "and" nor with "&&"

M1 = (CALCULATE(SUM('data (2)'[Estimative volume]),'data (2)'[Date de délistage]= "NA",'data (2)'[Statut Ref Com] = "Actuelle",'data (2)'[ORIGIN Indicator (code level) ] > 3 ,'data (2)'[Plant or Organism Scientific Name (genus + species)] = "A ,'data (2)'[Plant or Organism Scientific Name (genus + species)] = "B" )

Thanks in advance

[amitchandak · Accepted solution]

@akpresta ,  Try like

M1 = CALCULATE(SUM('data (2)'[Estimative volume]),
filter( 'data (2)' 'data (2)'[Date de délistage]= "NA" &&
'data (2)'[Statut Ref Com] = "Actuelle" &&
'data (2)'[ORIGIN Indicator (code level) ] > 3 &&
'data (2)'[Plant or Organism Scientific Name (genus + species)] in{ "A" , "B"} )
)

[akpresta]

Thank you very much

 It works perfectly 🙂