topic Re: SUMIF in DAX with filter - new measure in DAX Commands and Tips

SUMIF in DAX with filter - new measure

Anonymous — Thu, 29 Oct 2020 19:02:41 GMT

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?

Re: SUMIF in DAX with filter - new measure

mahoneypat — Thu, 29 Oct 2020 22:27:13 GMT

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