# Count members of Tempo Team

**URL:** <https://community.eazybi.com/t/count-members-of-tempo-team/5684>\
**Category:** Questions & Answers\
**Tags:** tempo, mdx\
**Created:** [November 26, 2020, 11:46am UTC](https://community.eazybi.com/t/count-members-of-tempo-team/5684 "2020-11-26T11:46:28Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![strojna.ewa](https://community.eazybi.com/user_avatar/community.eazybi.com/strojna.ewa/32/4136_2.png) [@strojna.ewa](https://community.eazybi.com/u/strojna.ewa)\
**Post date:** [November 26, 2020, 11:46am UTC](https://community.eazybi.com/t/count-members-of-tempo-team/5684/1 "2020-11-26T11:46:28Z")

</div>

Hi,

i was trying to count members of Tempo Teams (Logged by Team) but i always got 1.

I tried:

[Logged by].CurrentMember.Count

and

Count(  
[Logged by Team].CurrentMember  
)

and

Count(  
Descendants([Logged by Team].CurrentMember.Children)  
)

but it didn’t got me expected amount, only 1 or 0. ☹

How can i write this measure?

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [November 27, 2020, 2:24pm UTC](https://community.eazybi.com/t/count-members-of-tempo-team/5684/2 "2020-11-27T14:24:50Z")

</div>

Hi @strojna.ewa

Try creating a new calculated measure using this formula:

```
NonZero(
Count(
Filter(
Descendants([Logged by].CurrentHierarchyMember,[Logged by].[User]),
[Measures].[Hours spent]>0
)
)
)

```

It would count users from the “Logged by” dimension that have logged hours in the report context.

Martins / eazyBI team

---

<div class="post-metadata">

**Author:** ![strojna.ewa](https://community.eazybi.com/user_avatar/community.eazybi.com/strojna.ewa/32/4136_2.png) [@strojna.ewa](https://community.eazybi.com/u/strojna.ewa)\
**Post date:** [November 30, 2020, 9:00am UTC](https://community.eazybi.com/t/count-members-of-tempo-team/5684/3 "2020-11-30T09:00:34Z")

</div>

Thank you , but how to count all the team members even if they not log time?

I mean, in this measure i’ve got number of people from this team who logged time, but i want to know the number of the Team members regardless if they log time or not.

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [November 30, 2020, 9:20am UTC](https://community.eazybi.com/t/count-members-of-tempo-team/5684/4 "2020-11-30T09:20:56Z")

</div>

Hi,

“Logged by” dimension has only those users that has logged at least 1 time entry on imported issues.  
Otherwise, the user won’t be found in this dimension and this approach won’t work.

eazyBI imports data based on issues and worklogs.  
Inactive users are not imported in eazyBI.

see more details about the general user dimension here

> [@Ability to create groups dimensions from any user field](https://community.eazybi.com/t/ability-to-create-groups-dimensions-from-any-user-field/4171/2):
>
> Hi @grandeau! I am sorry for the delay in getting back to you about this! Unfortunately I do not have good news as eazyBI does not allow to create a user group dimension for other than default user-picker fields. @martins.vanags added this to eazyBI backlog based on your request some time ago and I upvoted this request again, but no estimates for now. If you are maintaining the Epic Assignee with a scripted field, maybe there is an option to get the Epic Assignee group in the same way? [Scripte…](https://docs.eazybi.com/eazybijira/data-import/data-from-jira-and-apps/jira-calculated-and-scripted-custom-fields)

The closest you could perhaps do is changing the formula so it searches for user worklogs through out whole history of issues (not just particular period of time)

```
NonZero(
Count(
Filter(
Descendants([Logged by].CurrentHierarchyMember,[Logged by].[User]),
([Measures].[Hours spent],[Time].Currenthierarchy.DefaultMember)>0
)
)
)

```

This calculation would check if the “Logged by” dimension member has logged time for the imported issues at all, no matter of when.

Martins / eazyBI support

---

<div class="post-metadata">

**Author:** ![strojna.ewa](https://community.eazybi.com/user_avatar/community.eazybi.com/strojna.ewa/32/4136_2.png) [@strojna.ewa](https://community.eazybi.com/u/strojna.ewa)\
**Post date:** [November 30, 2020, 9:25am UTC](https://community.eazybi.com/t/count-members-of-tempo-team/5684/5 "2020-11-30T09:25:16Z")

</div>

Thank you, everything clear

---

<div class="post-metadata">

**Author:** ![isnrao](https://community.eazybi.com/letter_avatar_proxy/v4/letter/i/f07891/32.png) [@isnrao](https://community.eazybi.com/u/isnrao)\
**Post date:** [May 11, 2021, 12:25pm UTC](https://community.eazybi.com/t/count-members-of-tempo-team/5684/6 "2021-05-11T12:25:17Z")

</div>

Sorry to open this thread again. Logged by gets you all the users (even if the user is not part of the Tempo Team). Is there a way to get only the members defined in the Tempo Team (as setup in JIRA)? Does this require any new admin setting to load this into eazyBI? It is OK if any of the Tempo team member did not log any time for the selected time/sprint.

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [May 11, 2021, 2:07pm UTC](https://community.eazybi.com/t/count-members-of-tempo-team/5684/7 "2021-05-11T14:07:37Z")

</div>

@isnrao

Try importing “Logged by Team” dimension and use it to filter your report.  
[https://docs.eazybi.com/eazybijira/data-import/data-from-jira-and-apps/tempo#Tempo-Dimensionsforworklogsandcustomfields](https://docs.eazybi.com/eazybijira/data-import/data-from-jira-and-apps/tempo#Tempo-Dimensionsforworklogsandcustomfields)

Martins / eazyBI team