Forum Discussion

smjzahid's avatar
smjzahid
Icon for Helper V rankHelper V
5 years ago

How to show 0% for null values using DAX

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

 
 

 

 

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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