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?
Example
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])
Best,
Roberts // support@eazybi.com