Forum Discussion
Measure that includes does not contain and countrows
Hi All,
I'm having an issue with the following measure
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.
Hi Anonymous ,
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.
2 Replies
Hi Anonymous ,
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.