https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Debug-Countrows-with-multiple-filters-error/m-p/1509044#M29299 <P>Anonymous</LI-USER>&nbsp; try change BLANK to BLANK()</P> Sun, 22 Nov 2020 08:56:54 GMT wdx223_Daniel 2020-11-22T08:56:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Debug-Countrows-with-multiple-filters-error/m-p/1508965#M29294 <P>Hi, I have a measure that counts number of items based on its <STRONG>Origin</STRONG> and <STRONG>Acceptance Datetime</STRONG></P><LI-CODE lang="markup">TotalACCEPtoRFIDINACCEPItems = CALCULATE(COUNTROWS('Scan Event DataQ'),FILTER('Scan Event DataQ',[ACCEPTANCE DATETIME]&lt;&gt;BLANK()&amp;&amp;Switch(True(), [OriginMailCentre]="Christchurch" &amp;&amp; [CHM RFID IN ACCEP DATETIME]&lt;&gt;BLANK,1, [OriginMailCentre]="Manawatu" &amp;&amp; [MTM RFID IN ACCEP DATETIME]&lt;&gt;BLANK,1, [OriginMailCentre]="Auckland" &amp;&amp; [AKM RFID IN ACCEP DATETIME]&lt;&gt;BLANK,1,0 )=1))</LI-CODE><P>However I get syntax error. Appreciate any help to resolve this. Thanks.</P> Sun, 22 Nov 2020 03:35:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Debug-Countrows-with-multiple-filters-error/m-p/1508965#M29294 Anonymous 2020-11-22T03:35:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Debug-Countrows-with-multiple-filters-error/m-p/1509044#M29299 <P>Anonymous</LI-USER>&nbsp; try change BLANK to BLANK()</P> Sun, 22 Nov 2020 08:56:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Debug-Countrows-with-multiple-filters-error/m-p/1509044#M29299 wdx223_Daniel 2020-11-22T08:56:54Z