**Need guidance on implementing AND logic for multiple Labels in an eazyBI report so the results match Jira filtering behavior without impacting the existing report.**

[zane.baranovska]

Hi @sudheer-kumar,

You are correct: when multiple labels are selected in the eazyBI page filter, the applied logic is OR (issues with any of the selected labels), which differs from Jira’s AND behavior.

There are two recommended approaches to implement AND logic for selected labels:

1. New dimension to represent label combinations dimension
   For better performance (especially with large datasets), the recommended approach is to import a pre-calculated “Label combinations” dimension. This avoids costly runtime iteration through all issues. See the community post for setup instructions:
   Multi labels dimension table - #2 by zane.baranovska

2. Calcaulted measure to count issues matching selected label set
   The calcaution woudl iterate though individual issues. For each issues it woudl count how many labels from the selected set it has; the “Issues created” measufre value increases for each label issue has from page filter. Then comapre this number with the total value of labels selected on page filter.

   NonZero(Count(
     Filter(
       DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
       --selected label count
       CalculatedChildrenSet([Label].CurrentHierarchyMember).Count
         --matches the count of labels issue has from selection
         = [Measures].[Issues created]
     )
   ))
   

   More details on calculated measures and mentioned functions are here: MDX function reference
   

   

Please note that the calculated measure is resource-intensive on larger data sets or complex reports, and it may impact report performance.

Best,
Zane / support@eazyBI.com