Hide Rows that have single value in cell

I am creating a report to surface any Story that is tagged with more than 1 sprint. I am using the measure as shown here:

[Sprint].[Sprint].getMemberNamesByKeys(
[Issue].CurrentHierarchyMember.get(‘Sprint IDs’)
)

The report returns all stories and lists the Sprint ID for each one in a row, based on my configuration. I want to hide any story that has sprint EMPTY (easy enough) and also any story that has 1 Sprint ID. This is the part I need help with. I only want to show rows where Sprint count > 1

Can you provide some guidance?
Please see screenshots.

Thanks,
Drew


Hi @drewwiseman,

Since you already have the Issue dimension on rows, you can access the issue property “Sprint IDs”.
You can look at that property as a list of references to the sprints, or you can look at it as a comma-separated list of numbers.

If you look for the issues with multiple sprints - you are looking for the lists with more than on entry. Since a coma separates multiple entries, you are actually looking for a comma in the property “Sprint IDs”.

Therefore, the expression to determine if the issue was related to multiple sprints might look as follows.

CASE WHEN
 CoalesceEmpty([Issue].CurrentHierarchyMember.Get('Sprint IDs'),'') MATCHES '.*,.*' 
THEN
--put here the actual calculation for the relevant issues 
1 
END

Since the “(no sprint)” has the ID of ‘-1’ and it is the only entry, this will also be excluded.

You might use this expression to filter rows based on measure values as described here - Create reports.
Alternatively, you might wrap other calculations within this condition to optimize the server load.

Regards,
Oskars / support@eazyBI.com

Oskars,

This was very helpful. Thank you!

Drew