Forum Discussion

ahiemstra's avatar
ahiemstra
Helper I
2 years ago
Solved

Multiple SUMIFs Functionality in DAX

I’m hoping for some help with a DAX. I’m trying to achieve the functionality of multiple SUMIFs in Excel and have searched the community to see if I could figure it out. Clearly, I’m missing somethin...
  • Fowmy's avatar
    Fowmy
    2 years ago

    ahiemstra 

    Try this measure:

    Indirect Service Hours =
CALCULATE (
    SUM ( 'ADMIN'[Time] ),
    'ADMIN'[Activity Type]
        IN {
            "Indirect Care Time",
            "No Show Cancel Time",
            "Rx Renewal Time",
            "Secure Message Time"
        }
)
Fowmy's avatar
Fowmy
Super User
2 years ago

ahiemstra 

Try this measure:

Indirect Service Hours =
CALCULATE (
    SUM ( 'ADMIN'[Time] ),
    'ADMIN'[Activity Type]
        IN {
            "Indirect Care Time",
            "No Show Cancel Time",
            "Rx Renewal Time",
            "Secure Message Time"
        }
)