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)
RE: Complex filter conditions
The OR filter and the Nesting functions are much needed, especially when looking into complex relations in data.
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.
RE: Complex filter conditions
use "||" in place of "OR"