Imagine, you want a report chart by month and you want to get the issues that are still in “Open” . Then you can create a Calculated Measure using Tuples.
For example, to get from the Issues Created, the Issues in “Open” status. You can use this tuple:
Then, to get the Date creation of the Issues you can use this formula:
Then the formula to get the still Open issues for each month can be this:
NonZero( Count( Filter( Descendants([Issue].CurrentMember, [Issue].[Issue]), DateInPeriod([Issue].CurrentMember.get('Created at'), [ ].CurrentHierarchyMember) AND ([Measures].[Issues created],[Status].[Open]) > 0 ) ) )