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', [...
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.

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.

PowerBINoob12's avatar
PowerBINoob12
Helper I
3 years ago

NM, removed the = for a comma. 

Thanks for your help