Use AND and OR in one filter

[Anonymous]

Hi,

Let me know if below formula is correct to calulcate (PM || ICD) AND ICM || ILR

Post Bill 30 =

CALCULATE(

    COUNT(MONITORING[BillingDOS30Day]),FILTER(CONTACTS_DEVICES_JOIN,(CONTACTS_DEVICES_JOIN[DeviceType]="PM" ||CONTACTS_DEVICES_JOIN[DeviceType]="ICD") && (CONTACTS_DEVICES_JOIN[DeviceType]="ICM" || CONTACTS_DEVICES_JOIN[DeviceType]="ILR")),

) + 0

[AlB · Accepted solution]

Hi @Anonymous 

It looks fine in general, only a closing parenthesis and a comma were misplaced. Try this minor modification:

Post Bill 30 =
CALCULATE (
    COUNT ( MONITORING[BillingDOS30Day] ),
    FILTER (
        CONTACTS_DEVICES_JOIN,
        ( CONTACTS_DEVICES_JOIN[DeviceType] = "PM"
            || CONTACTS_DEVICES_JOIN[DeviceType] = "ICD" )
            && ( CONTACTS_DEVICES_JOIN[DeviceType] = "ICM"
            || CONTACTS_DEVICES_JOIN[DeviceType] = "ILR" )
    )
) + 0