Filter None from a custom field

Questions & Answers
1

I have a custom field called Teams and selecting selecting all Teams has a value of None that I want to filter out as an option and having a hard time figuring out the calculated members to filter only that value from the list.

2

Hi Brian,

For such calculation, you would use Except(…) function in Team dimension. The formula would be similar to following

Aggregate(Except(
  [Team.[Team].Members,
  {[Team].[(none)]}
))

Let me know if there is anything else I can assist you with!
Kind regards,
Lauma / support@eazybi.com

1 Like
3

Hi Lauma,

I’m dealing with similar issue- but it doesn’t work for me. my calculate member is:

Aggregate(Except(
[Reporter].[system validation],
{[Reporter].[Customers]}
))

issues which appear(aggregate) in “customers” shouldn’t be appeared(aggregate) in “system validation” - Prevent overlap
Thanks

4

Hi Maya,

Both arguments of Except(…) function should be sets, but in your formula, I see the [Reporter].[system validation] is a member from Reporter dimension. If this is also a set of Reporters and you wish to exclude set of Customer reporters, you should use ChildrenSet(…) function as follows

Aggregate(Except(
  ChildrenSet([Reporter].[system validation]),
  ChildrenSet([Reporter].[Customers])
))

Lauma / support@eazybi.com