How to show 0% for null values using DAX

[smjzahid]

I have 3 separate measures shown below, It works fine,

Projects[Active Tasks] = CALCULATE(COUNTROWS('Tasks'),FILTER('Tasks','Tasks'[status] = "Active"))
Projects[Completed Tasks] = CALCULATE(COUNTROWS('Tasks'),FILTER('Tasks','Tasks'[status] = "Completed"))



Projects[Percent Complete] = DIVIDE([Completed Tasks],([Completed Tasks]+[Active Tasks]))

rather than showing nothing , I want to show 0% (where Active Tasks and Completed Tasks) are null, (see below highlighted in RED).

How do I modify above measure to achieve this, any help is appreciated

[amitchandak]

@smjzahid , Try like

Projects[Percent Complete] = DIVIDE([Completed Tasks],([Completed Tasks]+[Active Tasks]),0)

or

Projects[Percent Complete] = DIVIDE([Completed Tasks],([Completed Tasks]+[Active Tasks]))+0