Forum Discussion

justlearning50's avatar
2 years ago
Solved

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 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

4 Replies

    • justlearning50's avatar
      justlearning50
      Icon for Helper I rankHelper 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's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion

    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