How to count all issues that have component/s defined (without no component)

Questions & Answers
1

I’m trying to create a report to see the total number of tasks that have components defined.

2

Hi @evette.khalil
Welcome to the community!

You may want to create a calculated measure (in Measures) where you subtract issues without components from all the issues. If you select Project dimension projects in the report, this calculation works in each project level.

[Measures].[Issues created]
-
(
Filter(
 Descendants([Project].CurrentMember, [Project].[Component]),
 [Project].CurrentMember.Name = "(no component)"
 ).Item(0),
[Measures].[Issues created]
 )

Notice the subtractor is a tuple from the project’s component (no component) and measure. From the first glance, it does not seem like a tuple, but it is so: you may want to watch a presentation how to understand tuples.

Best,
Ilze / support@eazybi.com

3 Likes