topic Re: Help - Standard Deviation of Summarized Column in DAX Commands and Tips

Help - Standard Deviation of Summarized Column

Anonymous — Sat, 17 Apr 2021 18:19:09 GMT

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

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

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

Thanks in advance

AlB — Sat, 17 Apr 2021 19:38:40 GMT

Hi Anonymous

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

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 — Sat, 17 Apr 2021 19:41:41 GMT

Works amazing, Thanks.