Custom calculation member for non empty

Hello,

As simple but hard to get… I want to have in measures only OPEN issues with field “customer ID” not empty. I tryied:

NonZero(
([Measures].[Issues open],[Customer ID].[(none)])
)

Returns nothing…

Customer ID is a custom field imported as dimension and property

Not sure how many instances of CustomerID you have at your project. But you can create a definition for that like:

[Customer ID].[Customer filled]

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

Then you can do a tuple like:


(
[Measures].[Issues open],
[Customer ID].[Customer filled]
)

Other option is to create the measure to count the amount of open tickets and remove the ones with value empty:

[Measures].[Issues open]
-
(
[Measures].[Issues open],
[Customer ID].[(none)]
)
1 Like

Hi, @JakubDomino

Welcom to the eazyBI community.

Thanks, @Nacho, for the solution :). The Tuple is a powerful tool. Please read more here: Tuple

If you have the Customer ID dimension used in the report, then please use the DefaultMember in the formula. Please read more about DefaultMemeber here: DefaultMember

[Measures].[Issues open],
[Customer ID].DefaultMember
-
(
[Measures].[Issues open],
[Customer ID].[(none)]
)

Kindly,
Ilze