EazyBI - Create a Measures Calculated Member to count issues of a exact month

[Gustavo Lopes]

I'm trying to create a calculated member that counts all issues created in a exact month. For example, count all issues created in Aug 2018. However, I'm not being successful at this. I tried using DateBetween (https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/datebetween) but isn't counting any issues.

Can I limit the time range in exact dates, like 'Aug 01 2018' and 'Aug 31 2018', to count all these issues?

[Gustavo Lopes · Accepted solution]

I solved this by doing:

Count(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Open issues] > 0
and
DateBetween(
[Issue].CurrentHierarchyMember.get('Created at'),
'2018-08-1',
'2018-08-31'
)
)
)