Rolled up Unique Epic Count at the Issue level

I am trying to create a rolled up count of unique Epics at the Story level. I can’t seem to find the right CASE statement, IIF statement or anything to accomplish this. Is it possible?


Hi @Michael.Hermann,

It seems you are ordering the report rows by the Epic links. I suggest using the “Epic” hierarchy in the Issue dimension. With it, the Stories will be grouped under the Epics. After that, you can define a new calculated measure to return the number of Epics:

([Measures].[Issues created],
[Issue Type].[Epic])

Roberts //