Hi , i got a working measure using count filter but it’s way to slow.
I try to limit the set by making a first filter before checking the value on a custom measure.
here is my code :
-- Compare la date de transition à acceptance
--avec la date de fin de sprint
-- autheur : XHT
Count(
-- we used a first filter on issuetype to gain performance and avoid to calculate measure fo each issues
Filter( cache(
Filter( Descendants([Issue].CurrentMember, [Issue].[Issue]),
-- filters issues where measure En retard sur le Sprint Cible = 1
[Measures].[Issue type] = 'Feature'
OR
[Measures].[Issue type] = 'Enabler Feature'
AND
[Measures].[Issue PI]= [PI].CurrentHierarchyMember.Name
AND
[Measures].[Issue Sprint cible]= [Sprint cible].CurrentHierarchyMember.Name)
),
-- filters issues where measure En retard sur le Sprint Cible = 1
[Measures].[En retard sur le Sprint Cible] = 'OK'
)
)