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

amitchandak's avatar
amitchandak
Super User
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak, I get syntax error (the syntax for ',' is incorrect) when adding your measure:

     

    TotalACCEPtoRFIDINACCEPItems = CALCULATE(COUNTROWS('Scan Event DataQ'),FILTER('Scan Event DataQ',[ACCEPTANCE DATETIME]<>BLANK()&&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))