Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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()))))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
48 | |
45 | |
19 | |
16 |