Hello guys, I am trying to sum a jira issue field (Zendesk Ticket Count) group by Team and filtered by Time.
I have created this calculated measure “Total de tickets”>
SUM(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Team].CurrentHierarchyMember.Name = [Issue].CurrentHierarchyMember.Get(‘Team’)
),
[Issue].CurrentMember.Get(‘Zendesk Ticket Count’)
)
And a tuple measure “Total de chamados”>
([Measures].[Issues created count],
[Issue Type].[Chamado]
)
When filter my report by Year 2023 the “Total de chamados” measure is recalculated but my measure “Total de tickets” don’t (is it sum all the chamados for all times).
How do I make this field respect the filter Time? Thanks