"Cannot deduce type of set" error

Hi,

I have calculated member defined as:

SetToStr(
Filter(Descendants([Issue].[Issue].GetMembersByKeys([Is Blocked].CurrentMember.Get(‘Is Blocked’)), [Issue].[Issue]),
[Measures].[Issues created] > 0
))

and I get the following error when I try to use it

The same error also appears with other calculated fields whenever we want to use “Descendants([Issue].[Issue].GetMembersByKeys([Is Blocked].CurrentMember.Get(‘Is Blocked’)), [Issue].[Issue])” as a part of calculation.

[Is Blocked] definition:

[jira.customfield_is_blocked_link]
name = “Is Blocked”
inward_link = “is blocked by”
multiple_values = true
dimension = true

Can you advise please?
We use EasyBi Cloud / JIRA cloud

Hi @Izzy

Thank you for sharing your example!

In the Descendants() function, the first parameter must be a single dimension member (one), while GetMembersByKey() returns aggregated member set (all “is blocked” issue keys). Therefore, when you use a measure, the report returns ran error.

I would suggest using the DescendantsSet() function instead of Descendants(), which allows using exactly that: a member expression can be aggregated member set. DescendantsSet

DescendantsSet([Issue].[Issue].GetMembersByKeys([Is Blocked].CurrentMember.Get('Is Blocked')), [Issue].[Issue])
)

Best,
Ilze, support@eazybi.com