"Cannot deduce type of set" error


I have calculated member defined as:

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:

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])

Ilze, support@eazybi.com