# Calculated member excluding some labels **URL:** \ **Category:** Questions & Answers\ **Tags:** calculatedmembers\ **Created:** [March 24, 2021, 5:23pm UTC](https://community.eazybi.com/t/calculated-member-excluding-some-labels/6453 "2021-03-24T17:23:56Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\ **Post date:** [March 30, 2021, 3:33pm UTC](https://community.eazybi.com/t/calculated-member-excluding-some-labels/6453/2 "2021-03-30T15:33:42Z")
Hi @guinevere, The formula to aggregate several labels except the four listed is correct. This works well on overview reports; however, it might be too slow when drilling through individual issues as eazyBI validates all labels for each issue. There might be room for report optimization to match the main use case for a particular report and the data. ​ ​One method is to incorporate the label logic already in the calculated measures. ​There are few use cases > [@Find all issues without some labels](https://community.eazybi.com/t/find-all-issues-without-some-labels/2695): > > I try to find all issues without some labels. My issues have labels to dispatch between teams, and may have labels for something else. IssueA : LabelTeam1 IssueB : LabelTeam2 , OtherLabel1 IssueC : OtherLabel2 IssueD : (no label) I would like to find Issue not affected to a team (here C and D). But with my calculation, I also have B in the results. Columns: Measures/Open issues Row: Label with a new calculated member: Aggregate( Except( [Label].[Label].Members, { [Label].[L… > [@Multi values fields include and exclude values](https://community.eazybi.com/t/multi-values-fields-include-and-exclude-values/1194): > > How to handle multi value fields in MDX of calculated members When handling multi value fields, I would like to find a way to include some values and exclude some other values. For example, in ‘Label’ field, I want to count if the values have ‘A’ but have not ‘B’. I was using: Aggregate( Except( [Label].[A], [Label].[B] ) ) But the result still includes ‘B’ in label when both ‘A’ and ‘B’ are existing in the values. Can anyone help? Thanks! Best, Zane / [support@eazyBI.com](mailto:support@eazyBI.com) --- _[View the full topic](https://community.eazybi.com/t/calculated-member-excluding-some-labels/6453)._