Unique remaining items

[alonborn]

I’m trying to get remaining epics (issues which are still open). I’m currently using:

CASE WHEN DateDiffDays(Now(), [Time].CurrentHierarchyMember.Name) <= 0
THEN
[Measures].[Issues history] - [Measures].[Cumulative Issues Closed]
END

but then, when the issue has more than one team (there’s a customized field which can contain multiple values for team names) - it counts the same issue multiple times. I would like to count it only once. is there a way to do that?

[Elita.Kalane]

Hi @alonborn,

Welcome to eazyBI Community! Thanks for posting your question!

I recommend trying the solution described in this community post that explains how to use the distinct count measures. Since you are using measure “Issues closed”, please make sure you replace measure “Issues resolved count” with “Issues closed count” in the formula given in the Community post below:

Open issues for a suset of components

Hi @Manuel_Campana , Aggregates in multi-value fields tend to do that. The workaround is using distinct count measures. In the case of “Open issues”, which is a predefined calculated measure, it is based on the number of issues created and resolved. Create a new calculated measure which formula originates from “Open issues” and replace the measures “Issues created”, “Issues resolved”, and “Issues due” with the distinct count measures “Issues created count”, etc. See the formula below: CASE WHE…

Best wishes,

Elita from support@eazybi.com