Forum Discussion
Solved
Measure Returning More Rows and NaN value
Hi, I am writing the following measure which is working correctly but is returning a Nan value for one field. I have tried dealing with this Nan value by doing an if else measure. However when i ...
I believe i have found the solution. Please correct if wrong.
I have used the DIVIDE function which can handle the ability to divide by 0.
Labour Units Complete % = DIVIDE('P6 Measures'[Actual Hours],[At Completion Hours])
I believe i have found the solution. Please correct if wrong.
I have used the DIVIDE function which can handle the ability to divide by 0.
Labour Units Complete % = DIVIDE('P6 Measures'[Actual Hours],[At Completion Hours])