Count items with a certain value using a measure but return 0 if no value exists

[justlearning50]

Hi,

I have what I hope is an easy problem - I have a table with a column 'Skill Achieved'. The data is either 'Skill Achieved' or 'Skill Gap' based on a conditional statement on the individual results.

I created a measure that counts all the value of 'Skill Achieved' in a table as shown:

This works great except it does not return a zero if the skill is not achieved by anyone as shown below 

just gives a blank in 'Num Achieved Skill' Is there a way around this? 

NOTE: I do not want to show the 'Total Num of Results' measure in my report, so with just the 'Num Achieve Skill' column, many of my skills are omitted (which I do not want..)

I hope this is clear.

Thanks in advance for your help. 

M

[Dangar332 · Accepted solution]

HI, @justlearning50 

add +0 at end of your dax code like below
measure =
 calculate (

)+ 0

[justlearning50]

Thanks guys @PijushRoy , @Dangar332 , both options seem to work. Much appreciated.

[PijushRoy · Accepted solution]

Hi @justlearning50 

Please update your DAX

New Achieved Skill = 
IF(
ISBLANK(
Your full code code here),0,
Your full code code here)

Please paste your full DAX done in "Your full DAX code here" 

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush

[Dangar332 · Accepted solution]

HI, @justlearning50 

add +0 at end of your dax code like below
measure =
 calculate (

)+ 0

[justlearning50]

Thanks for coming back so quickly @Dangar332 . That has worked. It leaves me with a different issue, but hopefully one I can fix. Thanks again.