EazyBI question. How to filter by component

[Joe]

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?

[Daina Tupule]

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