Need count of Pod members

Questions & Answers
1

Hi All,

I have a problem where I need to see count of Pod Members since I am managing 5 different teams.

I tried Count ([Assignee].members) but it is not grouping it on the basis of POD and give a combine count
even Aggregate is not providing the desired result.

Output expected:

Team Count of Team members
Team A 9
Team B 7
Team C 6
Team D 10
Team E 5

2

Hi @Vipin_Joshi

Welcome to the Community! :dizzy:

First, to group your Assignees by Teams, please check out this guide by Zane: How to create a Team of assignees - #6 by zane.baranovska

When you’ve imported the Team property for Assignees and added the Team hierarchy to the Assignee dimension, you can select the “Team” level members for your report and use it together with a new calculated measure in the Measures dimension with the following formula:

Count(
  Filter(
    [Assignee].[User].Members,
    [Measures].[Issues created]>0
  )
)

You should be able to achieve the following report that will count how many members each team has:

team-level
team-level1212×900 73.9 KB

Let me know if this works as expected!
Nauris / eazyBI support