EazyBI Filter

[Anusha Balaji]

Hello,

I am trying to find the number of story points with the issue type of 'Story' for the last closed sprint. My dimension has only projects. Without selecting the issue type as 'Dimension', how can I create a calculated measure?

The below selects the last closed sprint

SUM(Tail(Filter(
[Sprint].[Sprint].Members,
[Measures].[Sprint Story Points committed] > 0
AND
[Sprint].CurrentMember.getBoolean('Closed')
), 1),
[Measures].[Sprint Story Points completed])

But when I add extra condition to pick only the issue type as Story, it doesn't work.

SUM(Tail(Filter(
[Sprint].[Sprint].Members,
[Measures].[Sprint Story Points committed] > 0
AND
[Sprint].CurrentMember.getBoolean('Closed')

AND

[Measures].[IssueType} = 'Story

), 1),
[Measures].[Sprint Story Points completed])

Please could you help? 

Many Thanks,

Anusha

[Liu.Jinming]

Don't use filter，it will make your system very slowly.

You can use the sprint demension.

If you want to design your own caculated members, Contact support@eazybi.com is the fastest way,they will be direct Write mdx for you.