Forum Discussion

justlearning50's avatar
justlearning50
Icon for Helper I rankHelper I
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 resul...
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    HI, justlearning50 

     

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

    )+ 0

  • PijushRoy's avatar
    PijushRoy
    2 years ago

    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's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

HI, justlearning50 

 

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

)+ 0

  • justlearning50's avatar
    justlearning50
    Icon for Helper I rankHelper I
    2 years ago

    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.