Forum Discussion
Solved
What is wrong with this DAX script?
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
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"}))
2 Replies
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"}))Thanks!
