Need help finishing my measure with a Contains section

[RichOB]

Hi, using my table below I need a measure that gives me a count of all incident types containing "Aggression". The measure I currently have only selects the singular/exact word and gives me a count of 1 where I need a count of 4. FYI, I need those dates in the measure too.

Aggression_24 = (

    CALCULATE(

        Count(Table[Incident_Number]),

        'Table'[Type_of_Incident] = "Aggression",

        'Tables'[Date]>=DATE(2024,1,1),

        'Table'[Date]<=Date(2025,9,1)

    ))

Date	Incident_Number	Type_of_incident
01/01/2024	1	Missing Person
01/02/2024	2	Fall
01/03/2024	3	Theft
01/04/2024	4	Aggression, Threats
01/05/2024	5	Aggression, ASB
01/06/2024	6	Theft
01/07/2024	7	Aggression, ASB, Violence
01/08/2024	8	Medical Concern
01/09/2024	9	Aggression

Thanks for your help

[RichOB]

Thanks very much @FreemanZ  !

[FreemanZ · Accepted solution]

hi @RichOB ,

try like:

Aggression_24 = (

    CALCULATE(

        Count(Table[Incident_Number]),

        CONTAINSSTRING('Table'[Type_of_Incident] ,"Aggression"),

        'Tables'[Date]>=DATE(2024,1,1),

        'Table'[Date]<=Date(2025,9,1)

    ))