DAX similar "SUMIFS()

[constanza]

I need to make a DAX similar in XLS as "·SUMIFS". If into de table called "fecha" it founds "julio", and in the column "familia" found "DOC", sum the column "Cto de Ventas"

[v-ljerr-msft · Accepted solution]

Hi @constanza,

You should be able to use the formula below to create a measure in your scenario. 

measure =
CALCULATE (
    SUM ( 'Table1'[Cto de Ventas] ),
    FILTER ( 'Table1', 'Table1'[fecha] = "julio" && 'Table1'[familia] = "DOC" )
)

Note: You'll need to replace 'Table1' with your real table name.

Regards

[Anonymous]

https://powerpivotpro.com/2009/12/powerpivot-dax-calculate-is-a-supercharged-sumif/