Original estimated hours & Hours spent by "Logged-by" and "Assignee""

Questions & Answers
2

Hi @Kira_Knightly

Welcome to the Community! :tada:

You can define a new calculated measure in the Measures dimension “Original est hours” with the following formula:

(
  [Measures].[Original estimated hours],
  [Assignee].[User].Members.Item([Logged by].CurrentHierarchyMember.Name),
  [Logged by].CurrentHierarchy.DefaultMember
)

This is a tuple, that addresses the Original estimates hours and finds the Assignee by the name of the current “Logged by” user. Finally, this formula ignores the current “Logged by” user and overrides it with the DefaultMember (“All Users”) member to not interfere with the result.

Let me know if this works as expected!
​Best regards,
​Nauris / eazyBI support