Exclude specific labels

calculatedmembers
#1

Hi,

I am trying to create chart with following query, i need exclude the issues which is having label2

project = “Project1” AND (labels = FWQA_TestDev AND labels != FWQA_Triage)

I tried with following calculated member without luck

Aggregate(
Filter
(
[Label].[Label].Members,
[Label].CurrentMember.Name MATCHES ‘FWQA_TestDev’
AND
[Label].CurrentMember.Name NOT MATCHES ‘FWQA_Triage’
)
)

Thanks,

#2

any help on this? or any reference document on how to do it?

#3

I’d like to know the answer. please help.

#4

Hi guys,

This post might help?:

Mark

#5

Hi @prasad and @enguyen,

The idea to use aggregate is correct. But in this case, to get the count of issues with specified labels you should aggregate issues instead of labels and for each issue validate assigned labels. For aggregation, you may use function Count() and iterate through issues using function Descendants()

NonZero(
Count(
  Filter(
    --iterate through issues
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    --which have label FWQA_TestDev
    ([Measures].[Issues created],
    [Label].[FWQA_TestDev]) > 0
    --and don't have lable FWQA_Triage
    AND IsEmpty(
      ([Measures].[Issues created],
      [Label].[FWQA_Triage]) )
  )
))

Best,
Zane / support@eazyBI.com

#6

Hi @zane.baranovska,

Thank you for helping. I tried to create a new calculated member and copied your suggestion for the contents but keeps getting error message "“Query execution timeout of 150 seconds reached. Please try to make query simpler”.

Do you have other suggestion how to get around this?

thx,

Erik