Aggregate all unreleased Fix Versions

Questions & Answers
1

Hello Community,
I’m trying to aggregate all Unreleased Fix Versions. something similar to:
Aggregate( [Fix Version.By status].[Unreleased].Members )
but it’s not working.
Can someone help?

2

Hi,

You could try the following code to aggregate all fix versions with unreleased status:

Aggregate(
Filter(
[Fix Version.By status].[Status].Members,
[Fix Version.By status].CurrentMember.Name = "Unreleased"
)
)

OR

Aggregate(
    Filter(
    [Fix Version.By status].[Version].Members,
    [Fix Version.By status].CurrentMember.Parent.Parent.Name = "Unreleased"
    )
    )

But note, it must be saved in correct hierarchy.

unreleased versions
unreleased versions2770×1570 480 KB

Kind regards,
Martins / eazyBI team

3

Thank you Martins! It works perfectly!