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
Nacho
June 12, 2024, 2:59pm
2
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