How to create a Custom Calculated Measure to count "Issue Created" instead of using predefined "Issue Created" measure

Deepak_Kumar · October 4, 2024, 10:54am

How to create a Custom Calculated Measure to count “Issue Created” instead of using predefined “Issue Created” measure.

This should work any filters on page like : Project, Project Name

ilze.mezite · October 10, 2024, 12:06pm

Hi, @Deepak_Kumar

Welcom to the eazyBI community.

What would be the purpose of such a measure?

Kindly,
Ilze

Deepak_Kumar · October 14, 2024, 6:54am

To get the count of Issue Created

ilze.mezite · October 29, 2024, 11:54am

Hi, @Deepak_Kumar

Measure “Issues created” is already a counter—it counts issues of any selection. When used with some dimensions, it might double the number of issues (for example if used together with the multi-value select field - like “Label”), so you can use a measure “Issues created count” instead.

However, if you would like to count members in other dimensions using this measure as a filter, you would like to use a custom calculation to count the members of the dimension that have any value in issues created.

For example, if you have a report with Project on Rows and you would like to count Assignees with assigned issues in each project, you can use this calculation to count Assignees (not issues):

Count(Filter(
  DescendantsSet([Assignee].CurrentMember, [Assignee].[User]),
  [Measures].[Issues created] > 0))

Here are the 3 measures together:

Kindly,
Ilze