Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Riddell2023
New Member

Standard Deviation HELP!!!

Current ModelCurrent Model

Good Afternoon, I am really struggling with a DAX calculation to do the same as the above. Please could someone help as I am pulling my hair out

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @Riddell2023 

 

Please check the following methods.

Column:

En SdDev Diff =
IF (
    [Band] <> BLANK (),
    ROUND ( [En Diff] / STDEV.S ( 'Table'[Assessment% ] ), 2 ),
    BLANK ()
)

vzhangti_0-1642487519343.png

Are some of our results inconsistent because there are hidden decimal points in the data image you provided?

 

Best Regards,

Community Support Team _Charlotte

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

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @Riddell2023 

 

Please check the following methods.

Column:

En SdDev Diff =
IF (
    [Band] <> BLANK (),
    ROUND ( [En Diff] / STDEV.S ( 'Table'[Assessment% ] ), 2 ),
    BLANK ()
)

vzhangti_0-1642487519343.png

Are some of our results inconsistent because there are hidden decimal points in the data image you provided?

 

Best Regards,

Community Support Team _Charlotte

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

amitchandak
Super User
Super User

@Riddell2023 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

refer if this can help

https://p3adaptive.com/2013/10/standard-deviation-demystified-in-power-pivot/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors