Count Issue when Reporter matches Assignee

Questions & Answers
,
1

Hello,

I have been searching all day and I cannot figure out what I am doing wrong.
I have two reports one by Assignee (counting xray test run statuses)
image

and another by Reporter (counting Xray tests created).
image

I would like to combine them because:
1 - list of names is the same
2 - The Reporter table has one measured column

Based on the measure in 3 Assignee Hours - Issues - eazyBI Demo Training - eazyBI
I created the following measure, but it returns no values.

(
  [Measures].[Xray Tests created],
    [Reporter].[User].GetMemberByKey(
    [Assignee].CurrentHierarchyMember.Key)
)
2

Hi, @Camille

Welcom back to the eazyBI community.

You are close!

When the context is switched (Assignee → Reporter), the old dimension (Assignee) should be reset to the default ([Assignee].CurrentHierarchy.DefaultMember) to avoid affecting measures unrelated to that dimension.

The dimension-switching part should look something like this:

CASE 
WHEN 
[Reporter].CurrentHierarchyMember IS [Reporter].CurrentHierarchy.DefaultMember
AND
[Assignee].CurrentHierarchyMember.Level.Name = 'User'
THEN
(
  [Measures].[Xray Tests created],
    [Reporter].[User].GetMemberByKey(
    [Assignee].CurrentHierarchyMember.Key),
    [Assignee].CurrentHierarchy.DefaultMember
)
END

If your Reporter and Assignee groups are calculated members or groups, the calculation might be more complex, and you might want to send more information and report definition to the support@eazybi.com

Kindly,
Ilze

3

Hi @ilze.mezite

I tried this, but get the following error:
image

Can you help? I have no idea what that error means.

–Also noting in case it matters–
I have changed the people dims to use ones that can’t be edited:
Reporter > Now using Creator (verified I correctly imported this)
Assignee > Now Using Xray Test Executed by

CASE 
WHEN 
[Creator].CurrentHierarchyMember IS [Creator].CurrentHierarchy.DefaultMember
AND
[Xray Test Executed by].CurrentHierarchyMember.Level.Name = 'User'
THEN
(
  [Measures].[Xray Tests created],
    [Creator].[User].GetMemberByKey(
    [Xray Test Executed by].CurrentHierarchyMember.Key),
    [Xray Test Executed by].CurrentHierarchy.DefaultMember
)
END