Beginner Question: XRAY and components

Questions & Answers
2

Hi,

If the Tests Created shows correct number by components, the formula can be a bit simpler for filtering the Tests, but it needs one more part when counting the test runs:

sum(
Filter(
      Descendants([Xray Test].CurrenthierarchyMember, [Xray Test].[Test]),
     [Measures].[Xray Tests created]>0
    ),
   ([Measures].[Xray Test Runs],
   [Component].DefaultMember)
  )

The default member of the Component dimension ignores the Component for test runs. The use of Xray Tests created measure filters the tests by component.

Kindly,
Janis, eazyBI support

1 Like