Two filter conditions with OR operation on one page

[lkshck]

Hey,

I want to use a filter on a page which uses an OR condition. I have two fields called "JsonTags.area" and "ReservationName". My goal is to display data on the page where "JsonTags.area" is equal "dl-business-intelligence" OR "ReservationName" contains "DWH". I think this will be only possible via new Column or with Measure but would be glad to get some help on it.

Br

[v-angzheng-msft · Accepted solution]

Hi, @lkshck 
Create a calculated column with the following formula:

Column =
IF (
    [JsonTags.area] = "dl-business-intelligence"
        || CONTAINSSTRING ( [ReservationName], "DWH" ),
    1,
    0
)

Then filter the items at the page filter level for column values equal to 1.

e.g.
 

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lkshck]

Works fine, thank you!

[mh2587]

You can simply do this from page filter by draging both the mentioned fields

[lkshck]

This works only for the same field, right? So If I put the field "JsonTags.area" to the Page filters, I can select advanced filtering and set an OR condition but not between two fields.