Filtering rows based on two column values

[Nikolaikruger]

Hi, 

New to DAX and pretty new to PowerBI. 

I would like to write a DAX expression that displays rows when two string values are met in a column: 

I tried creating a new table and using a filter expression but then I can only get one condition added: 

Test = Filter(Dim_ProjectFilter, Dim_ProjectFilter[Activity]="Commencement of Treatment") 

I would like to also filter for a second string value - what is the syntax for that? 🙂 

[tamerj1 · Accepted solution]

Hi @Nikolaikruger 
You can use something like

Test =
FILTER (
    Dim_ProjectFilter,
    Dim_ProjectFilter[Activity] IN { "String1", "String2" }
)