Measure Shows Blank Rows

Question

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

mfelix · Answer

Hi&nbsp;Hasan_iba,&nbsp;Looking at your file you can achieve this by using this measure:&nbsp;Member_N = CALCULATE            (                DISTINCTCOUNT(Resources[ResourceId]),               Resources[TeamName] = ALLSELECTED(ResourceDemandTimephasedDataSet[Team])            )Hope this helps,&nbsp;Regards,MFelix

hasan_iba · Answer

Hi&nbsp;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

mfelix · Answer

Hi&nbsp;Hasan_iba,&nbsp;Do you want th total number of Resources in the Team, or the total identified in the ResourceDemandTimephasedDataSet table that are from that team?&nbsp;The measure I made was based on the table resource so it counts all the team members.&nbsp;Regards,MFelix

hasan_iba · Answer

hi&nbsp;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,&nbsp;resource ID shows only one resource ID for procurement team, the total team members column shows 3 the existence of 3 members,&nbsp;for service desk team, it shows 31 members while there are only 3 unique resource ID.&nbsp;we are getting some strange team member count for service desk, procurement and operations centre teamif 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

Forum Discussion

Measure Shows Blank Rows

4 Replies

Related content

Incorrect totals showing in matrix from measure showing blanks

M Formula - Show 0 instead of (blank)

Blank columns when doing Measure Name Measure Value approach

DAX Countrows showing as blank but should show thousands

Blanks showing in table visual