cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
crmiller1201
Frequent Visitor

Is it possible to put an OR clause between two different page filters?

As an example, I want to filter a page to show orders where the customer name contains "key word" OR the product name contains "Key word"

 

In the advanced filter, I see that there is an option to add an or clause but only within the same filter. 

4 REPLIES 4
claymcooper
Resolver II
Resolver II

Is there a need to have it formatted as "key word" vs "Key word"? If not, you could change the values or replace them in the query editor.

Yes, unfortunately I have to keep it formatted the way it currently is. They need to be able to look at a complete list of orders that meet either of the criteria specified. The issue is that each criteria relies on filtering two different columns of data. 

crmiller1201
Frequent Visitor

Thank you for the response. The "Key word"s will change though based on what the viewer wants to see. I need to provide the end user with a way of applying an OR clause between two page filters if that is somehow possible?

erothen
Frequent Visitor

Without seeing your data, my initial suggestion would be to create a new calculated column that indicates whether each row (order) should be included in the filter. Let me know if this solution works for you.

 

IfFiltered = IF(OR(CONTAINS('Table', 'Table'[Customer Name], "key word"), CONTAINS('Table', 'Table'[Product Name], "key word")), "Yes", "No")

 

Helpful resources

Announcements
collabdays lisbon

CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.