Allow me to specify OR conditions across fields in filters. For example "Where sales > 10000 OR where name = 'UK'"
5 Comments
- use "||" in place of "OR"
- 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.
- The OR filter and the Nesting functions are much needed, especially when looking into complex relations in data.
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.
- Status added:Completed
