Sum of the actual Test Cases in the Test Cycles

Questions & Answers
, ,
1

Hello everyone,
I want to display the amount of the sum of the actual test cases in runs. Now the sum of the current and archived ones is displayed.

Example:

Sum(
Filter(
  [Measures].[TM4J Test Cases with Test Cycles],
  [Measures].[TM4J Test Case Archived?] = 'Actual'
  ))
2

Hi @Maria,
Sum() function needs a measure by which to sum the result and Filter() function needs a set from which to filter the results.
Try this formula:

Sum(
  --go through all test cases
  Filter(
    Descendants([TM4J Test Case].CurrentMember,[TM4J Test Case].[Test Case]),
  --filter by actual
    [Measures].[TM4J Test Case Archived?] = 'Actual'),
  --sum by measure
  [Measures].[TM4J Test Cases with Test Cycles]
)

best,
Gerda // support@eazyBI.com