Help Creating a Filter in calculated measure

Questions & Answers
1

I have circa 500 issues. When each issue achieves a status of “Ready for Check” it should have hours logged against it using the time tracking metric. Is there a way to create a calculated measure that will look at each issue, says has is it at or has it gone past the “Ready for Check” status, if it has have there been any hours logged against the work. If it has not gone into or past the “Ready for Check” status it can just be ignored.

2

Hi @CKirkland,

Welcome to the eazyBI Community!

Depending whether you have the Issue dimension in Rows or not, try the options below:

If Issue dimension is in Rows, define a new calculated measure (learn more here - Calculated measures and members) with the formula below:

CASE
WHEN
(
  [Measures].[Transitions to status],
  [Transition Status].[Ready for Check]
)>0
THEN
[Measures].[Hours spent]
END

If you don’t have the Issue dimension in Rows, try defining a new calculated measure with the formula below:

Sum(
Filter(
  Descendants([Issue].CurrentMember,[Issue].[Issue]),  
 (
  [Measures].[Transitions to status],
  [Transition Status].[Ready for Check]
)>0),
  [Measures].[Hours spent]
)

Best wishes,

Elita from support@eazybi.com