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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Help - Standard Deviation of Summarized Column

Hi,

I would like to request your help to create a measure that calculates the Standard Deviation of a summarized column, I have this table:

 

Table

IDValue
A2
A3
B4
B5
C6
C7

 

I need to calculate the Standard Deviation, but I need to do it after sumarizing the values of each ID as follows:

 

IDSum Value
A5
B9
C13

 

So, I just need the measure that gives me the final STDev which would be: 4

 

Thanks in advance

1 ACCEPTED SOLUTION
AlB
Community Champion
Community Champion

Hi @Anonymous 

Measure =
STDEVX.S ( DISTINCT ( Table1[ID] ), CALCULATE ( SUM ( Table1[Value] ) ) )

 

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

View solution in original post

2 REPLIES 2
AlB
Community Champion
Community Champion

Hi @Anonymous 

Measure =
STDEVX.S ( DISTINCT ( Table1[ID] ), CALCULATE ( SUM ( Table1[Value] ) ) )

 

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

Anonymous
Not applicable

Hi @AlB 

Works amazing, Thanks.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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