SUMIF in DAX with filter - new measure

[Anonymous]

Hello!

I'm creating a measure called Adj New Biz and I would like it to function as such:

SUMIF (Project_Group_ID = NBIZ) OR ((Project_Group_ID = INT) AND CategoryName = "Marketing/New Business" or "Business Development"

So you see I'm just making sure all of INT's hours that were related to new business and business development are added into everything that is under project group ID NBIZ.

Not sure of an easier way to do this. I do not want to make a table, but would rather have a measure.  Still pretty new to DAX.  Any advice? Am I asking for two much from a measure? Should I try and code a table instead?

[mahoneypat · Accepted solution]

You are right to try to this as a measure.  Here is an expression that should work.

Sum Measure =
CALCULATE (
    SUM ( Table[Hours] ),
    FILTER (
        ALLSELECTED (
            Table[Project_Group_Id],
            [CategoryName]
        ),
        OR (
            Table[Project_Group_Id] = "NBIZ",
            AND (
                Table[Project_Group_Id] = "INT",
                Table[CategoryName]
                    IN {
                    "Marketing/New Business",
                    "Business Development"
                }
            )
        )
    )
)

Regards,

Pat