# Need to use Assignee and Logged by in the same report

**URL:** <https://community.eazybi.com/t/need-to-use-assignee-and-logged-by-in-the-same-report/4677>\
**Category:** Questions & Answers\
**Created:** [June 16, 2020, 8:58pm UTC](https://community.eazybi.com/t/need-to-use-assignee-and-logged-by-in-the-same-report/4677 "2020-06-16T20:58:49Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![roberts.cacus](https://community.eazybi.com/user_avatar/community.eazybi.com/roberts.cacus/32/637_2.png) [@roberts.cacus](https://community.eazybi.com/u/roberts.cacus)\
**Post date:** [July 6, 2020, 10:16am UTC](https://community.eazybi.com/t/need-to-use-assignee-and-logged-by-in-the-same-report/4677/2 "2020-07-06T10:16:36Z")

</div>

Hi @Vero,

You can try to create a new calculated measure that will look for the number of hours spent where the currently selected assignee is also the one who logged the hours. Please have a look at the linked eazyBI community posts below:

> [@Original estimated hours vs hours spents](https://community.eazybi.com/t/original-estimated-hours-vs-hours-spents/3143/2):
>
> Hi @Roberto_Zambrano, welcome to eazyBI community! slight_smile You can create a report by using Assignee dimension in the rows, with this you will get original estimates per assignee. After that you can find the same user as Assignee from the Logged by dimension with [GetMemberByKey()](https://docs.eazybi.com/display/EAZYBI/GetMemberByKey) function and display their Hours spent with the following formula: ( [Measures].[Hours spent], [Logged by].[User].GetMemberByKey( [Assignee].CurrentMember.Key ) ) The report would look like thi…

> [@Issues assigned but no hours spent](https://community.eazybi.com/t/issues-assigned-but-no-hours-spent/2220/2):
>
> Hi Alan, You can find the same user as Assignee from the Logged by dimension with [GetMemberByKey()](https://docs.eazybi.com/display/EAZYBI/GetMemberByKey) function and display their Hours spent per issue with the following formula ( [Measures].[Hours spent], [Logged by].[User].GetMemberByKey( [Assignee].CurrentMember.Key ) ) You could then create the following report Note that I have added Issues created filter greater than zero to display all issues of the assignee also getting the ones where nobody has logged any …

And also, a report from the eazyBI Demo account - [3 Assignee Hours - Issues - eazyBI Demo Training - eazyBI](https://eazybi.com/accounts/22010/cubes/Issues/reports/376181-3-assignee-hours).

The eazyBI documentation has more details on creating calculated measures - [Calculated measures and members](https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members).

Best,  
Roberts // [support@eazybi.com](mailto:support@eazybi.com)

---

_[View the full topic](https://community.eazybi.com/t/need-to-use-assignee-and-logged-by-in-the-same-report/4677)._
