No information on parent groups for a property issue

Hello, I start in the creation of calculated field and I need help.

In jira I have a specific field “N° de Ticket CRM” which is imported into EazyBi as an issue property.

The field is empty or fill with string.
I have this information only on the lines issue.

I would like from any dimension to be able to count the number of issues with a “N° de Ticket CRM” to make a statistic

Here is the property field :

[Issue].CurrentHierarchyMember.get('N° de ticket CRM')

This is what i can only get on the issue :

In yellow a column propertie and in red my count column.

But my count column is not good because i cont only issue and not other dimension.

My user define field :

CASE WHEN Not IsEmpty([Issue].CurrentHierarchyMember.get('N° de ticket CRM')) 


But with the dimension Time I always have zero, then I would like the number of issue with a value in the field “N° de Ticket CRM”

Thanks for your help

I want value in cell “Issue N° de ticekt CRM” or “TicketCRM count”.
I want sum of “Issue N° de ticket CRM” for my dev.

We can see on this screenshot that I have the green line that is correct. But the red lines that are groupings of me do not give me the sum of the green line. I have an empty cell so I should have 1

Hi @MiH,

To get the count of issues where this field is not empty, try creating a new calculated measure, using the Filter() and Descendants() functions:

  Not IsEmpty([Issue].CurrentHierarchyMember.get('N° de ticket CRM'))
  [Measures].[Issues created] > 0

You can read more about these functions on our documentation page -

Kind regards,
Roberts // eazyBI support