Forum Discussion

micklowe's avatar
micklowe
Helper I
1 year ago
Solved

Using the DIVIDE Function

Hi I'm having a few problems with the NaN and Infinity errors on a calculation field, I believe the solution is to use the DIVIDE function but I'm having problems getting this to work.    This is ...
Need Help
  • HarishKM's avatar
    HarishKM
    1 year ago

    micklowe Hey,
    you can write your dax like this.
    Utilisation = 
    Var _a = [productive_time]
    VAR _b=( [WorkingHours]-[non_productive_time])

    return

     = divide(_a,_b,0)*100


    you can try above dax.

    Thanks

    Harish M

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HarishKM's avatar
HarishKM
Super User
1 year ago

micklowe Hey,
you can write your dax like this.
Utilisation = 
Var _a = [productive_time]
VAR _b=( [WorkingHours]-[non_productive_time])

return

 = divide(_a,_b,0)*100


you can try above dax.

Thanks

Harish M

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.