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: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
BeaudryL
Frequent Visitor

Possible to calculate standard deviation based on a matrix summary column?

‎02-07-2025 01:36 PM

 

BeaudryL_0-1738962930645.png

 

https://www.dropbox.com/scl/fi/9ise1lk7e442f5vvgpfzh/StdDev-Test-Cleaned.pbix?rlkey=sj822rz8594jmj6y...

 

https://www.dropbox.com/scl/fi/c7lz8k1sc7ceeyo595i58/StdDev-Test-Data-Cleaned.xlsx?rlkey=qjt7ycncdwg...

 

Labels:
Message 1 of 3
143 Views
0
1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

‎02-07-2025 01:56 PM

@BeaudryL 

Please use this measure:

STD Dev = 
VAR __MeanByClinician = 
    ADDCOLUMNS(
        SUMMARIZE( MENTORS , MENTORS[Clinician] ),
        "@Mean" , CALCULATE( AVERAGE( MENTORS[Response.Value] ) )
    )
VAR __StdDev = STDEVX.P( __MeanByClinician , [@Mean] )
RETURN
    __StdDev



Did I answer your question? Mark my post as a solution! and hit thumbs up


⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

View solution in original post

Message 2 of 3
117 Views
0
2 REPLIES 2
BeaudryL
Frequent Visitor

‎02-07-2025 10:13 PM

Well, that was easy. Thank you!! 

Message 3 of 3
72 Views
Fowmy
Super User
Super User

‎02-07-2025 01:56 PM

@BeaudryL 

Please use this measure:

STD Dev = 
VAR __MeanByClinician = 
    ADDCOLUMNS(
        SUMMARIZE( MENTORS , MENTORS[Clinician] ),
        "@Mean" , CALCULATE( AVERAGE( MENTORS[Response.Value] ) )
    )
VAR __StdDev = STDEVX.P( __MeanByClinician , [@Mean] )
RETURN
    __StdDev



Did I answer your question? Mark my post as a solution! and hit thumbs up


⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

Message 2 of 3
118 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

View All
Top Kudoed Authors
View All