cancel
Showing results for
Did you mean:
Post Partisan

## standard deviation formula and its calculation

Hi All,

I have facing problem while calculating Standard deviation .

Actually I am getting wrong value for standard deviation.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

## Re: standard deviation formula and its calculation

You may check the following DAX that adds a measure.

```Measure =
CALCULATE ( STDEV.P ( Table1[Duration in Hours] ), ALL ( Table1 ) )
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Champion

## Re: standard deviation formula and its calculation

Which function do you use? DAX or Power Query (M)?

Specializing in Power Query Formula Language (M)
Post Partisan

## Re: standard deviation formula and its calculation

Hi,

I am using DAX function . I want Standard deviation of entire employees.

The data image as given below

Regards,

Arvind

Community Champion

## Re: standard deviation formula and its calculation

DAX is not my specialty.

My advice would be to give ALL relevant information DIRECTLY when you are asking a question on a forum.

So helpers don't need to ask for it:

1. You didn;t tell which DAX function you use,
2. What do you get as a result,
3. Is it always worng or only in specific situations (e.g. after filtering).
4. What should the result be and why?

Specializing in Power Query Formula Language (M)
Community Support

## Re: standard deviation formula and its calculation

You may check the following DAX that adds a measure.

```Measure =
CALCULATE ( STDEV.P ( Table1[Duration in Hours] ), ALL ( Table1 ) )
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors