Forum Discussion
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...
You can adjust your measure
Measure = IF(SUM('Table'[SpecificTime])=0,0,DIVIDE(SUM('Table'[SpecificTime]),SUM('Table'[TotalTime])))
You can adjust your measure
Measure = IF(SUM('Table'[SpecificTime])=0,0,DIVIDE(SUM('Table'[SpecificTime]),SUM('Table'[TotalTime])))