How to create various dimension filters

Questions & Answers
1

Hi. I want Filter by some Label OR some Priority.

So i wrote down.
Is it right to fill it out with the following?

calculated Dimension is “Label” in Pages.

Aggregate(
Filter(
[Label].Members,
[Label].CurrentHierarchyMember.Name MATCHES “1st” OR
[Label].CurrentHierarchyMember.Name MATCHES “EUM/CAR/need” OR
[Label].CurrentHierarchyMember.Name MATCHES “EUM/CAR” OR
[Label].CurrentHierarchyMember.Name MATCHES “EUM/CAR5/13” OR
[Label].CurrentHierarchyMember.Name MATCHES “EUM/CAR5/14” OR
[Label].CurrentHierarchyMember.Name MATCHES “EUM/CAR5/15” OR
[Label].CurrentHierarchyMember.Name MATCHES “EUM/CAR5/17” OR
[Label].CurrentHierarchyMember.Name MATCHES “EUM/CAR5/18” OR
[Priority].CurrentHierarchyMember.Name MATCHES “Top” OR
[Priority].CurrentHierarchyMember.Name MATCHES “A”
)
)

Thanks.

2

Hi,
In this case, you would first need to create two separate calculated members (one in “Label” dimension, another in “Priority”) that would aggregate all necessary members from both Labels and Priorities.
Try this example for “Label” dimension

Aggregate({
[Label].[1st],
[Label].[EUM/CAR/need],
[Label].[EUM/CAR]
})

And another one in “Priority”

Aggregate({
[Priority].[Top],
[Priority].[A]
})

And then you can create a new calculated measure in “Measures”

    (
[Measures].[Issues created count],
[Label].[new calculated label]
)
+
(
[Measures].[Issues created count],
[Priority].[new calculated priority]
)
-
(
[Measures].[Issues created count],
[Label].[new calculated label],
[Priority].[new calculated priority]
)

Martins / eazyBI support

1 Like