Forum Discussion
Measure Shows Blank Rows
Hi Hasan_iba,
Looking at your file you can achieve this by using this measure:
Member_N = CALCULATE
(
DISTINCTCOUNT(Resources[ResourceId]),
Resources[TeamName] = ALLSELECTED(ResourceDemandTimephasedDataSet[Team])
)
Hope this helps,
Regards,
MFelix
Hi MFelix, thanks for the quick reply. I applied your provided expression. It works to some extent and does not so some extent as well. The following image should clarify. As you can see, although the Operations centre team shows only 3 resource ID, the table shows team members of 15. That is quite strange. Can you suggest a way to resolve this issue? I want to have the same number of members as the number of resource ID. Thanks
Hi Hasan_iba,
Do you want th total number of Resources in the Team, or the total identified in the ResourceDemandTimephasedDataSet table that are from that team?
The measure I made was based on the table resource so it counts all the team members.
Regards,
MFelix
hi MFelix, thanks again for making suggestion. I want to use resource_demand_timephased table. However, the use of resource table do generate correct values for some of the teams and do not generate correct values for others. For example,
resource ID shows only one resource ID for procurement team, the total team members column shows 3 the existence of 3 members, for service desk team, it shows 31 members while there are only 3 unique resource ID. we are getting some strange team member count for service desk, procurement and operations centre team
if it works for the other teams, i am not getting it why its showing strange values for the other teams (service desk, procurement and operations centre team). Thanks