Hi there,
I’m new with EazyBI and I need to create a report to sum “issue OOM Est. days” group by Clients
I started with 2 dimensions “Issue” , “Client - Business Unit” and a measure ([Measures].[Issue OOM Est. Days] = [Issue].CurrentHierarchyMember.get(‘OOM Est. Days’)
My code is the following:
OOM Mandays =
Sum(
Filter(Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]), [Measures].
[Issue OOM Est. Days]>0)
, [Measures].[Issue OOM Est. Days]
)
But the result is always the sum of all at the client level
Could you please help me with the correct code I should use?
Many thanks for your help!