Im sorry that maybe i do not understand basic principles of working with eazyBI.
I want to filter one measure that contains SLA Elapsed time by another measure ( resolved issues on 1st line of support on a period of time).
For example, on october 2018 was resolved 80 issues.
Resolution time complete cycles measure contains 85 issues by the same period. (Issue has complete cycle only in status “closed” but when it on status “resolved”, sla on pause)
I need to get average time by divide this 2 measures. Count of members should be equal.
I’m trying to filter members from [Measures].[nominator] that in [Measures].[Resolved on 1st line].
I don’t understand how to write logic expression for this filter
Aggregate( Filter( Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]), [Measures].[nominator].CurrentHierarchyMember IS [Measures].[Resolved on 1st line].CurrentHierarchyMember ) )
I trying to use this formula as expression:
[Measures].[nominator].Default = [Measures].[R>Inc: 1L]
But its not right and filter not worked properly.
I’d be very grateful for all your advices.