Countrows with many filters/conditions

Anonymous — Mon, 23 Nov 2020 05:53:09 GMT

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

Re: Countrows with many filters/conditions

wdx223_Daniel — Mon, 23 Nov 2020 06:46:20 GMT

Anonymous

TotalACCEPtoRFIDINACCEPItems = COUNTROWS(FILTER('Scan Event DataQ',[ACCEPTANCE DATETIME]<>BLANK()&&(([OriginMailCentre]="Christchurch" && [CHM RFID IN ACCEP DATETIME]<>BLANK())||( [OriginMailCentre]="Manawatu" && [MTM RFID IN ACCEP DATETIME]<>BLANK())||[OriginMailCentre]="Auckland" && [AKM RFID IN ACCEP DATETIME]<>BLANK()))))

Re: Countrows with many filters/conditions

Anonymous — Mon, 23 Nov 2020 08:01:47 GMT

Thank you wdx223_Daniel , much appreciated

topic Re: Countrows with many filters/conditions in DAX Commands and Tips

Countrows with many filters/conditions

Re: Countrows with many filters/conditions

Re: Countrows with many filters/conditions