Hi. My current measure is not returning correct count of items based on 3 conditions/filters i.e. Acceptance date, Origin, and Location Entry Date
TotalACCEPtoRFIDINACCEPItems = CALCULATE(COUNTROWS('Scan Event DataQ'),FILTER('Scan Event DataQ',[ACCEPTANCE DATETIME]<>BLANK()&&Switch(True(),
[OriginMailCentre]="Christchurch" && [CHM RFID IN ACCEP DATETIME]<>BLANK(),'Scan Event DataQ'[TotalItemsLodged],
[OriginMailCentre]="Manawatu" && [MTM RFID IN ACCEP DATETIME]<>BLANK(),'Scan Event DataQ'[TotalItemsLodged],
[OriginMailCentre]="Auckland" && [AKM RFID IN ACCEP DATETIME]<>BLANK(),'Scan Event DataQ'[TotalItemsLodged],0)))
The logic should be:
if [OriginMailCentre] = "Auckland" && [Acceptance Datetime] <> Blank() && [AKM RFID IN ACCEP DATETIME]<>Blank(), return row count
else
if [OriginMailCentre] = "Manawatu" && [Acceptance Datetime] <> Blank() && [MTM RFID IN ACCEP DATETIME]<>Blank(), return row count
else
if [OriginMailCentre] = "Christchurch" && [Acceptance Datetime] <> Blank() && [CHM RFID IN ACCEP DATETIME]<>Blank(), return row count
