Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Icon for Helper IV rankHelper IV
2 years ago
Solved

Custom if statement for Percentages

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/result...
Need Help
Tips and Tricks
Tutorial Requests
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    You can adjust your measure

     

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

Kaviraj11's avatar
Kaviraj11
Icon for Solution Sage rankSolution Sage
2 years ago

You can adjust your measure

 

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