Count epics and count >=!

Questions & Answers
1

Hi,
I have this table

image
image1243×539 37.2 KB

I do not know how to count table lines (50 is the result o sum al “issues created count”, but I would like to count each line) and I would like to count how many are bigger than one

Thanks

2

Hi @aelexpuru,

You can create a calculated measure or counting rows in the report. The key function here is VisibleRowsSet() (function description the documentation: VisibleRowsSet - eazyBI).

For example, this code will show the count of rows (underlying members) for the top hierarchy member:

CASE WHEN --top hierarchy member
   [Issue].CurrentHierarchyMember is [Issue].CurrentHierarchy.DefaultMember
THEN --count of all rows except for itself
  Count( 
    VisibleRowsSet() 
  ) - 1
END

eazyBI count issues on report rows
eazyBI count issues on report rows1694×1426 188 KB

Best,
Zane / support@eazyBI.com