Excel to DAX: converting SUMIFS structured references

[HowardFrazier76]

I am trying to convert a SUMIFS excel statment to DAX 

I have 

=SUMIFS(mast[PHTUTS],mast[PHPSTF],"10")+SUMIFS(mast[PHTUTS],mast[PHPSTF],"11") and I am tying to convert into a DAX statment 

[HowardFrazier76]

Thanks 

[AilleryO · Accepted solution]

Hi,

According to what I can see, if you just create a table on your report with mast[PHPSTF] on the lines, 

and with mast[PHTUTS] in values, you should have the total for each value (10,11...).

Otherwise in DAX it will look like :

CALCULATE( SUM(mast[PHTUTS]),mast[PHPSTF]=10) or

CALCULATE( SUM(mast[PHTUTS]),mast[PHPSTF]="10") depending on type (numeric or text).

or could be :

CALCULATE( SUM(mast[PHTUTS]),mast[PHPSTF] IN {10,11})

Hope it helps