Hide rows in EazyBI without removing

Questions & Answers
1

Hi,
i need to hide rows with issue summary ‘Sounds approval’ without removing them,
and leave only issues with summary ‘Sketches’
as i get some info from it.
I’ve tried to define calculated measure for the row but it won’t work:

Aggregate(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Issue].CurrentMember.Name MATCHES ‘.Sketches.’
)
)

Please advise how it’s better to do it

eazybi - sound status
eazybi - sound status1320×339 96.7 KB

2

Hi,

Your aggregated member is close to the correct (the pattern matching needs leading and trailing asterisks):

Aggregate(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Issue].CurrentMember.Name MATCHES ".*Sketches.*"
  )
)

We, however, do not recommend this solution since it has a risk of performance problems.
A workaround is to implement a new Javascript calculated custom field to filter the issues with the naming pattern using a new dimension.

Please, check a similar community post about this solution: Filter open issue by summary.

Kindly,
Janis, eazyBI support