Custom if statement for Percentages

[nataliesmiy1357]

Hello!  I am trying to track the percentage of downtime minutes.

I have a calculation for a specific time / total time.  But some columns just have zeros, so I am getting a bunch of answer/results of "NaN"

How is it possible to create an if statment to make the NaN values 0?

[Kaviraj11 · Accepted solution]

You can adjust your measure

Measure  = IF(SUM('Table'[SpecificTime])=0,0,DIVIDE(SUM('Table'[SpecificTime]),SUM('Table'[TotalTime])))