Creating a calculated measure under Labels for issue without a specific label

Questions & Answers
1

Hi all,

I’m trying to create a calculated measure under Labels what will give me all the issues that doesn’t have a specific label but my current solution gives me also issues that has the label I don’t want to see if they have other labels:
Aggregate(
Except(
[Label].[Label].Members,
Filter(
[Label].[Label].Members,
[Label].CurrentHierarchyMember.Name MATCHES ‘SystemE2E_Test_By_Team’
)
)
)
what do I need to do to get only the issues that doesn’t have this label even if they have other labels?
any help will be appriciated.

Thanks,
Ori Cohen

2

Hi @Ori_Cohen,

A warm welcome to the eazyBI community :tada: !

Labels is a multi-value field. Each issue that has multiple labels selected will have a value for each of the dimension members. Thus, excepting one of them doesn’t remove the issue from the equation, as it will show up for the others.

Instead of a calculated member in the Label dimension, I recommend defining a calculated measure in Measures to view the count of issues without a specific label. The formula in your case could look similar to the one below:

(
  [Measures].[Issues created],
  [Label].DefaultMember
)
-
(
  [Measures].[Issues created],
  [Label].[SystemE2E_Test_By_Team]
)

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com