Filter Gallery Help

[Jason_Hough]

hi there, 

I have a CDS that i use ClearConnect to get a local copy - all working fine. 

I need to do a filter and the filter is : If businessGroup = Variable and Criticality = Varible and this works perfectly by : 

Filter(ContactListLocal, BusinessGroup=BG, Severity=Criticality)

but if i want to add another filter : 

Filter(ContactListLocal, BusinessGroup=BG, Severity="ALL") - that works perfectly as well - so it shows rows when severity is ALL. but how do i combine them together - so it shows the rows with severity of Criticality and ALL ? 

Multiple filters do not work for me, any help would be fab. 

[CarlosFigueira · Accepted solution]

You can use the Or operator to combine the two expressions:

Filter(
    ContactListLocal,
    BusinessGroup = BG,
    Severity = Criticality Or Severity = "ALL")

That will give you the contacts in the business group that have the severity either the value of the Criticality variable, or the value "ALL".