Skip to main content
Microsoft Idea

Power BI


Complex filter conditions

Vote (56) Share
Power BI Ideas Admin's profile image

Power BI Ideas Admin on 03 Oct 2014 07:14:27

Allow me to specify OR conditions across fields in filters. For example "Where sales > 10000 OR where name = 'UK'"

Administrator on 09 Jul 2021 18:51:25

You can handle OR conditions through DAX in PowerBI. Here's the documentation on how to write an OR statement in DAX - OR function (DAX) - DAX | Microsoft Docs

Comments (3)
Power BI Ideas Admin's profile image Profile Picture

Mary Donlon on 05 Jul 2020 23:27:45

RE: Complex filter conditions

The OR filter and the Nesting functions are much needed, especially when looking into complex relations in data.

Power BI Ideas Admin's profile image Profile Picture

Greg on 05 Jul 2020 23:17:41

RE: Complex filter conditions

In addition to having the option of OR'ing and/or AND'ing various filters together, I wish Power BI supported the usage of parentheses () to group them together. For example: Where ( Diagnosis IN ('1234','2468') And Category = 1 ) OR (Diagnosis IN ('9876','3333') And Category IN (5,6) ). This is a simple example of complexity - there are lots of more complex queries we wish we could support. Or, maybe this could be accomplished if Power BI allowed us to pass in the equivalent SQL Where clause; it could be a separate editable text area for the Where (Filter) expression. And just like with DAX expressions, Power BI would only allow it if it passes validation.

Power BI Ideas Admin's profile image Profile Picture

Shashi on 05 Jul 2020 23:01:06

RE: Complex filter conditions

use "||" in place of "OR"