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.