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:

([Measures].[Issues created],[Status].[Open])

Then, to get the Date creation of the Issues you can use this formula:

[Issue].CurrentMember.get(‘Created at’)

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'),
      [Time].CurrentHierarchyMember) 
	AND
    ([Measures].[Issues created],[Status].[Open]) > 0
 )
)
)
Posted by:.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s