filter based on 2 conditions

[Manar]

Hi,

I am trying  to filter in power bi desktop using 2 conditions, I have a report with Field 1 and Field 2,  would like to filter when Field1 >1000 or field2 >1000.

Is this possible?

thank you 

[stretcharm · Accepted solution]

Yes

There is an OR  function.

https://msdn.microsoft.com/en-us/query-bi/dax/or-function-dax

Some details on logical filters are covered in the blog post

https://www.sqlbi.com/articles/the-in-operator-in-dax/

[Anonymous · Accepted solution]

Hi @Manar,

You could create a column Condition:

If(OR(Table[Field1]  > 1000, Table[Field2]  > 1000), "True", "False")

Now, you can use this column Condition as a filter.

Is this what you were looking for?

[stretcharm · Accepted solution]

Yes

There is an OR  function.

https://msdn.microsoft.com/en-us/query-bi/dax/or-function-dax

Some details on logical filters are covered in the blog post

https://www.sqlbi.com/articles/the-in-operator-in-dax/