I am creating a calculated member of one of my Reports and it has some conditions.
I want to have issues having exact text in the issue Summary. But it Issue Summary ,I want to use the text only not the issue key.
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
NOT isEmpty( [Issue].CurrentHierarchyMember.get(‘Assessment’))
and [Value Stream name].CurrentMember.Name = [Issue].[Issue].GetMemberByKey([Issue].CurrentHierarchyMember.get(‘Assessment’))
.get(‘Summary’)
and [Risk Subcategory].CurrentMember.Name = [Issue].CurrentHierarchyMember.get(‘Risk Subcategory’)
)
Here Assessment in a Linked Issue Member