Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure that includes does not contain and countrows

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 tha...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you! This works perfectly.