Is there a way to return an AND in Page Filter when selecting multiple values

Questions & Answers
1

Hi,

I’ve noticed that Page Filter dropdowns use an OR operator when selecting multiple values. Is there a way to return an AND?

In my example I’m using Zephyr Scale Test Case Labels as a Page Filter. I would be like to be able to select two (or more if possible) Labels here and only return values that have Label1 AND Label2…not the current behavior of Label1 OR Label2 which will return every Test Case that has both labels.

The usecase is being able to Label something in Zephyr as, for example, “Automated” and “BillingCenter” so I can produce a grid of testcases that are automated in BillingCenter (because they have both labels). Right now when I try this it brings back all testcases with those Labels

eazybiquestion
eazybiquestion978×460 35.8 KB

2

Hi @leng064

That is correct, Page filters work as with the “OR” operator.

You can write a custom measure that will check if the selections match the labels for each Test Case.

Here’s a similar example with Issues and issue Labels:

NonZero(
Count(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Issues created]
    =
    Count(ChildrenSet([Label].CurrentHierarchyMember))
  )
))

Let me know if you need help adjusting the code with the name of the measure that you are currently using in the report!
​Best regards,
Nauris / eazyBI support