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

[Anonymous]

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

[tex628 · Accepted solution]

Hi, 

Try this:

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

[Anonymous]

Thank you very much @tex628 . It worked well.