Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Countrows with multiple conditions

I have a measure that counts the number of items based on the Origin and Acceptance Datetime:   TotalACCEPtoRFIDINACCEPItems = CALCULATE(COUNTROWS('Scan Event DataQ'),FILTER('Scan Event DataQ','Sc...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous  , add

    && Switch ( True () ,
    [OriginMailCentre]="Christchurch" && [CHM RFID IN ACCEP DATETIME]<>BLANK,1 ,
    [OriginMailCentre]="Manawatu" && [MTM RFID IN ACCEP DATETIME]<>BLANK,1 ,
    [OriginMailCentre]="Auckland" && [AKM RFID IN ACCEP DATETIME]<>BLANK,1 ,0
    ) =1

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, Anonymous , you might want to try amending your measure this way,

TotalACCEPtoRFIDINACCEPItems =
CALCULATE (
    COUNTROWS ( 'Scan Event DataQ' ),
    FILTER (
        'Scan Event DataQ',
        'Scan Event DataQ'[OriginMailCentre] = "Auckland"
            && 'Scan Event DataQ'[ACCEPTANCE DATETIME] <> BLANK ()
            || 'Scan Event DataQ'[OriginMailCentre]
            IN { "Christchurch", "Manawatu", "Auckland" }
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    CNENFRNLthank you for your suggestion however your measure does not include the Acceptance Datetime columns i.e. [CHM RFID IN ACCEP DATETIME], [MTM RFID IN ACCEP DATETIME], [AKM RFID IN ACCEP DATETIME]