Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
arvindyadav
Post Partisan
Post Partisan

standard deviation formula and its calculation

‎08-03-2017 08:41 PM

Hi All,

 

I have facing problem while calculating Standard deviation .

Please help me out.

Actually I am getting wrong value for standard deviation.

 

 

Labels:
Message 1 of 5
1,946 Views
0
1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support
In response to arvindyadav

‎08-07-2017 12:05 AM

@arvindyadav,

 

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.

View solution in original post

Message 5 of 5
2,680 Views
0
4 REPLIES 4
MarcelBeug
Community Champion
Community Champion

‎08-03-2017 08:45 PM

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

Specializing in Power Query Formula Language (M)
Message 2 of 5
1,944 Views
0
arvindyadav
Post Partisan
Post Partisan
In response to MarcelBeug

‎08-03-2017 08:56 PM

Hi,

 

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

 

 

The data image as given below

 

Standard deviation trail.png

Regards,

Arvind

Message 3 of 5
1,940 Views
0
v-chuncz-msft
Community Support
Community Support
In response to arvindyadav

‎08-07-2017 12:05 AM

@arvindyadav,

 

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.
Message 5 of 5
2,681 Views
0
MarcelBeug
Community Champion
Community Champion
In response to arvindyadav

‎08-03-2017 09:05 PM

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)
Message 4 of 5
1,937 Views

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All