What is wrong with this DAX script?

[pmcinnis]

Would appreciate it if someone could correct my error in the following DAX script:

res ct finished =

CALCULATE(

   COUNTROWS('Data'),

      FILTER(

         ALLEXCEPT('Data','Data'[Parameter]),[Sample Type]="TREATED WATER" OR "DISTRIBUTION"))

When I enter the above script to create a new measure in Desktop, I get the following error:  The syntax for 'OR' is incorrect. (DAX(CALCULATE(COUNTROWS('Data'),FILTER(ALLEXCEPT('Data','Data'[Parameter]),[Sample Type]="TREATED WATER" OR "DISTRIBUTION")))).

I've tried different syntax variations, but no luck getting it to work. Thanks

[az38 · Accepted solution]

Hi @pmcinnis 

try

res ct finished =
CALCULATE(
   COUNTROWS('Data'),
      FILTER(
         ALLEXCEPT('Data','Data'[Parameter]),[Sample Type]="TREATED WATER" || [Sample Type]="DISTRIBUTION"))

or

res ct finished =
CALCULATE(
   COUNTROWS('Data'),
      FILTER(
         ALLEXCEPT('Data','Data'[Parameter]),OR([Sample Type]="TREATED WATER", [Sample Type]="DISTRIBUTION")))

or

res ct finished =
CALCULATE(
   COUNTROWS('Data'),
      FILTER(
         ALLEXCEPT('Data','Data'[Parameter]),[Sample Type] IN {"TREATED WATER", "DISTRIBUTION"}))

[pmcinnis]

Thanks!