Forum Discussion

PowerBINoob12's avatar
PowerBINoob12
Helper I
3 years ago
Solved

Adding containstring to a measure

Hi

I have the below measure that counts all the rows in the "incident tickets" table where the "assignment group" is equal to "incident"

 

Ticket Count = COUNTROWS(FILTER('Incident Tickets', [Assignment group] = "Incident")

How would I change this to count all the rows in the "incident tickets" table where the "assignment group" contains the string "incident"

 

I know I need to use the contrainsstring() but not sure how to structure it

Thanks

Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    Hi PowerBINoob12 

    try with

    Ticket Count = 

    COUNTROWS(

              FILTER(

                      'Incident Tickets',

                      CONTAINSSTRING('Incident Tickets'[Assignment group] = "incident")

    )

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

3 Replies

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    Hi PowerBINoob12 

    try with

    Ticket Count = 

    COUNTROWS(

              FILTER(

                      'Incident Tickets',

                      CONTAINSSTRING('Incident Tickets'[Assignment group] = "incident")

    )

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

    • PowerBINoob12's avatar
      PowerBINoob12
      Helper I
      3 years ago

      I get this error then:

      Too few arguments were passed to the CONTAINSSTRING function. The minimum argument count for the function is 2.