Hi,
I want to use this filter to get the label from one personal defined formula, but it doesn’t work.
Aggregate(
Filter(
[Label].[Testing],
[Label].CurrentHierarchyMember.Name NOT MATCHES “xxx-Mode”
))
It always gets the total members of [Label].[Testing], no just the members without “xxx-Mode”.
May I ask how to fix it?
Thanks.
Hi @Newbyhehe
Dealing with multi-value field dimensions such as “Label” is always tricky.
Some Jira issues can have more than one label, so it is almost challenging to exclude just one, and keep the other, and at the expect correct results for measures in report.
Please share more details about the use-case and the formula for the calculated member “Testing” in the Label dimension.
What measures do you want to calculate exactly (count, average, sum, etc.), and what other dimensions do you use in the report?
Here is one use case with Label as CSV dimension that creates all possible label combinations in new dimension as dimension members. That would let you use it as a single-value dimension, and then aggregate + except would work much simpler.
Martins / eazyBI