Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@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()))))
@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()))))
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |