Good afternoon. Looking for assistance on a quick problem. I’m building a report that shows Content (Issue Type) that is not assigned to a Sprint. The problem comes into play when I have team members that have tagged content issues types as tasks and stories. So I built a calculated member, [Issue Type].[Tasks and Stories] that sums up all the tasks and stories.
But having trouble filtering that to only include those that have the word “content” in their summary.
A summary is a free format text and not well suited for filtering data. Anyhow, there are several options to do this.
You can define a new calculated measure in Measures that would go through all issues and check on the Summary field for each. This is quite a resourceful calculation and might impact report performance. (More details here in the documentation: Calculated measures)
Please see this community post for more details on this solution: