How to exclude a cascading child values in measures

I have a Cascading Custom field in JIRA Module -> Parent & Child.
E.g.
Parent values: Home, Login, Logout
Child: Home-Inbox, Home-Search, Login-Message, Logout-Mail

I need to exclude only Issues in Child value Home-Search. How to create this measure to aggregate all other issues.

Whether below one will work?

Aggregate(
Except(
[Module].AllMembers,
{[Module].[Second].[Home-Search]})

Hi @Vishnu,
A calculated member in Module dimension that returns all child options except Home-Search would look like this:

Aggregate(
  Except(
  [Module].[Second].Members,
  {[Module].[Home].[Search]}
  )
)

With cascading select you need to specify the level at what you are doing a search.

best,
Gerda // support@eazyBI.com

Thank you. It worked.

1 Like