Count of text field

I’m trying to filter for a text field, (at the moment we don’t have it as a dimension) so I’m trying to get the aggregate or count of the field “Issue Present in Test Cycle” when the text contains “uat”. (It won’t be exactly UAT - just needs to contain that text somewhere in the field) Does anyone know the next steps I should take? Thank you!

Screen Shot 2022-07-20 at 12.33.05 PM

Hi @Stevie_Clark ,
If you don’t have this field as a dimension, but only as a property (at least so it seems from the name “Issue Present in Test Cycle”), then you can filter your issues using Filter() and DescendantsSet() functions.
Here is an example where I am using “Issue labels” property (change “Issue labels” to your issue property). The measure is linked to the Time dimension by issue creation date, you can change “Issues created” to another measure if needed:

Sum(
  Filter(
    DescendantsSet([Issue].CurrentHierarchyMember, [Issue].CurrentHierarchy.Levels("Issue")),
    CoalesceEmpty([Issue].CurrentHierarchyMember.get('Labels'), '') MATCHES ".*app_2.*"
    AND
    [Measures].[Issues created]>0  
  ),
  1
)

In the report:

best,
Gerda // support@eazyBI.com