Forum Discussion

HowardFrazier76's avatar
HowardFrazier76
Frequent Visitor
4 years ago
Solved

Excel to DAX: converting SUMIFS structured references

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 
Need Help
  • AilleryO's avatar
    AilleryO
    4 years ago

    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

AilleryO's avatar
AilleryO
Memorable Member
4 years ago

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