Forum Discussion
Count items with a certain value using a measure but return 0 if no value exists
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
Hi justlearning50
Please update your DAXNew 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
4 Replies
- Dangar332
Resident Rockstar
- justlearning50
Helper I
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.
- PijushRoy
Community Champion
Hi justlearning50
Please update your DAXNew 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 - justlearning50
Helper I