Hi, I'm trying to filter my data by component value.
for example,
I want to pull out the data that have
(Component 1 or Component 2 or Component 3) AND (Component 4 or Component 5 or Component 6)
Any help?
You would like to use issue-level calculation for this filter. You can check particular component values with a function MATCHES in a property Issue components. The property is available released on cloud and with version 6.1 on a server.
Here is an example formula for this:
Sum(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
CoalesceEmpty([Measures].[Issue components], "") MATCHES ".*Component 1.*|.*Component 2.*|.*Component 3.*"
AND
CoalesceEmpty([Measures].[Issue components], "") MATCHES ".*Component 4.*|.*Component 5.*|.*Component 6.*"
),
[Measures].[Issues created]
)
Daina / support@eazybi.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.