Standard Deviation grouped by day

[Bela_ICP]

Hi! I'm a beginner at PBI and need help calculating the standard deviation of a set of numbers.

I want the standard deviation for the amount of sales grouped by day:

But since my table has multiple rows for the same day, the measure I tried to use is getting this value considering each recorded number.

How could I correct the measure in pbi for obtaining 4.92?

https://www.dropbox.com/s/bwa3i19ubrx3ndt/Standard%20Deviation.pbix?dl=0

Thanks.

[PurpleGate · Accepted solution]

Hi,

You can use this measure

Standard Deviation = 
STDEVX.P(SUMMARIZE('Table','Table'[Date]),CALCULATE(SUM('Table'[SalesAmount])))