We use a custom field on our Epics that has predefined values in a drop down and you can select a single value. The custom field’s name is “Strategic Driver” and there are several predefined values.
I want to sum all story points under epics given the Strategic Drive for all epics.
I have a measure that will count the number of Epics given the Strategic Drive but ChatGPT and trying to configure based off of it’s output have yet to work.
So given in my Project there are 10 Epics and 3 of the Epics have custom field ‘Strategic Driver’ set to ‘Platform Investments’ and of the 2 Epics have custom field ‘Strategic Driver’ set to ‘Run the Business’ , etc. I want to count all child stories of those Epics as a measure and already have the Strategic Driver as a dimension. I will have that dimension as Rows and want the columns to display the total story points with a table report.
The Epic Count measure is
sum([Issue Type].[epic].[Strategic Driver].CurrentHierarchyMember.Children)