Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Add zero or null in a column which does not have a value

Hello All,

 

I have 4 columns picks up data.

Sometime there is no data in a column, and it shows empty as you can see under the Minor risk ratings column. . 

Please see the screenshot below.
Is there anyway, to add a zero or null when there is no value in a column?

 

For example: The current formula for Minor risk ratings is:

 

Minor risk ratings = CALCULATE(COUNTA('Risk'[Current risk ratings]), 'Risk'[Current risk ratings] IN { "Minor" })
 
 
Looking forward to hearing from you.
 
Thank you for your reply and support.
 
Dersim
 
  • Hi, 

    Try this:

    Minor risk ratings = CALCULATE(0 + COUNTA('Risk'[Current risk ratings]), 'Risk'[Current risk ratings] IN { "Minor" })

2 Replies

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion

    Hi, 

    Try this:

    Minor risk ratings = CALCULATE(0 + COUNTA('Risk'[Current risk ratings]), 'Risk'[Current risk ratings] IN { "Minor" })
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you very much tex628 . It worked well.