cancel
Showing results for
Did you mean:
Frequent Visitor

## Getting Standard Deviation on counts if ID rolled off at month level

Hello Power BI team,

I am trying to get Standard deviation based on monthly count but running into issues. I was not able to use biult in function STDEV but did not work wondering if anyone was able to calculate Standard deviation on scenario shown an in attached .pbix?

https://1drv.ms/u/s!Ak_CUb7-a3wXakVfzU08cCNSHBE

TIA

1 ACCEPTED SOLUTION

Accepted Solutions
New Contributor

## Re: Getting Standard Deviation on counts if ID rolled off at month level

```Standard Deviation Attempt =
STDEVX.P(
SUMMARIZE(
'Fact',
DimDate1[Month],
DimName[Name]
),
"Count",
[ActualCount]
),
[ActualCount]
)```

6 REPLIES 6
Highlighted
Frequent Visitor

## Re: Getting Standard Deviation on counts if ID rolled off at month level

Hi Sam, this worked for my scenario recently using Matt Ellington's solution:

Monthly Standard Deviation with Calendar = CALCULATE(
STDEVX.P('DimDate1',
[Monthly Avg]),
ALL('DimDate1'[Month])
Frequent Visitor

## Re: Getting Standard Deviation on counts if ID rolled off at month level

@sajidtp  Hi thanks for your relpy, following measure is returning  0.41 as standard deviation but in actual it should be 5.9, any thoughts?

Frequent Visitor

## Re: Getting Standard Deviation on counts if ID rolled off at month level

Hi @Sam01 negative, newbie to Std. Dev. as well... still learning...

New Contributor

## Re: Getting Standard Deviation on counts if ID rolled off at month level

```Standard Deviation Attempt =
STDEVX.P(
SUMMARIZE(
'Fact',
DimDate1[Month],
DimName[Name]
),
"Count",
[ActualCount]
),
[ActualCount]
)```

Frequent Visitor

## Re: Getting Standard Deviation on counts if ID rolled off at month level

@Nick_M  Perfect, thank you so much.

Frequent Visitor

## Re: Getting Standard Deviation on counts if ID rolled off at month level

Thank you @Nick_M this is awesome!