Beginner Question: XRAY and components

Questions & Answers
5

Here, I updated the initial formula using properties instead of measures to filter Xray tests faster when the report uses the Component dimension.

SUM(
Filter(
   Descendants([Xray Test].CurrenthierarchyMember, [Xray Test].[Test]),
     iif([Component].CurrentMember.Level.Name = 'Component', 
       [XRAY Test].CurrentHierarchyMember.get('Component') MATCHES '.*' || [Component].CurrentMember.Name || '.*' , 1 
    )),
   ([Measures].[Xray Test Runs], [Component].DefaultMember)
  )

It might work faster and apply fewer calculations using measures that minimize memory use.

However, you would like to use measures iterating through Tests in accounts with a small set of issues. For example, issues for a specific project only.

Daina / support@eazybi.com