Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi. all the experts. Hope all of you are doing great!! Recently, I am having a problem with a dax measure. There is a measure named number of members which calculates the total number of members a specific team contains. The problem with the measure is that the measure does not show values whenever there is no value in the demand column. I want to have value for team member column irrespective of the value of the demand column. The attached pbix file will be helpful to have a look at the situation in depth.
https://drive.google.com/file/d/0B0XwYvmbIN12UUIya0JUS0tmYWs/view?usp=sharing
A prompt solution will be highly appreciated. Thank you
Hasan
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêshi @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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |