Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Standard Deviation without considering 0

Good afternoon capos, I am trying to calculate the standard deviation based on the yield what happens is that it brings 0 (zeros) then the deviation comes out an absurd value I have tried to do it w...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Syndicate_Admin ;

    Please try to create a measure to calculate the standard deviation.

    standard deviation = STDEVX.P(ALL('Table'),DIVIDE([Volume (Tons)],[Hours Worked (Hours)]))

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Syndicate_Admin ;

Please try to create a measure to calculate the standard deviation.

standard deviation = STDEVX.P(ALL('Table'),DIVIDE([Volume (Tons)],[Hours Worked (Hours)]))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.