Forum Discussion
Anonymous
5 years agoNot applicable
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" })