My sincere apologies for such delay. May has been extremely busy for us with Atlassian event and eazyBI Community days here in Riga and also vacation time. If you contact us at support@eazybi.com you will hear back from us faster.
But here’s a possible solution on your case, fingers crossed it works for you!
Use the regular dimension (not the CSV) to filter the required result, in my example, I’m using “Fruits” Dimension filtering by “Apple”. As you can see by Issue property, the issues might have more than one fruits, including Apple
By creating a new calculated measure, you could remove the unnecessary fruits (the filtered value is crucial in this case, as it indicates which value has to be displayed)
Please replace the “Fruits” dimension name to your custom field name.
--generating a new list of names
Generate(
--filtering matching fruits only
Filter(
--create a list of fruits selected in pages
DescendantsSet(
[Fruits].CurrentHierarchyMember,
[Fruits].[Fruits]),
--condition for filter - issue relates to the fruit
[Measures].[Issues created]>0),
--retrieving the name of the filtered fruit
[Fruits].CurrentHierarchyMember.Name,
--split by comma
","
)
Best wishes,
Elita from support@eazybi.com