Filtering rows based on two column values

Nikolaikruger — Tue, 13 Sep 2022 09:14:59 GMT

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? 🙂

Re: Filtering rows based on two column values

tamerj1 — Tue, 13 Sep 2022 09:17:58 GMT

Hi Nikolaikruger
You can use something like

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

topic Filtering rows based on two column values in DAX Commands and Tips

Filtering rows based on two column values

Re: Filtering rows based on two column values