Measure that includes does not contain and countrows

[punksterz626]

Hi All,

I'm having an issue with the following measure

calculate(COUNTROWS(Query1),Query1[DURATION]<>BLANK(),FILTER(Query1,Query1[CodeName]<>"%SVC%"))

The objective is to count rows that are not blank; however, i have 5 rows that have a value of "0" which should be included in this measure but it is not. It seems as though 0 is considered a blank. I also want to exclude anything that has "SVC" in the CodeName column, but it doesn't look like it is doing that with the above measure. Any help would be greatly appreciated.

[Anonymous · Accepted solution]

Hi @punksterz626 ,

According to my understanding, you want to count rows when [DURATION] <>BLANK and [CodeName] do not contains "SVC".

Please try:

Measure = CALCULATE(COUNTROWS('Query1'),FILTER('Query1',ISBLANK([DURATION])=FALSE() && CONTAINSSTRING([CodeName],"SVC")=FALSE()))

 Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[punksterz626]

Thank you! This works perfectly.