Problem with STDEV

[Ortignano]

Hello,

I have  a table with error and week ID reference. I create a visual like below:

Error    Last7DaysError    STDEV_of_last12_week

Err 1

Err2

..

Err n

And I try to calculate the standard deviation of each err over the last 12 weeks using

STDEV_of_last12_week = STDEVX.P(FILTER(ALL('Calendar'),

'Calendar'[WeekID]<=MAX('Calendar'[WeekID]) &&

'Calendar'[WeekID]>=MAX('Calendar'[WeekID])-11

),

[CountError]

)

but comparing with the same table in excel it doesn't give me the correct result. I don't if I'm make some error in claculation

Thank you

[amitchandak · Accepted solution]

@Ortignano , 12 weeks calculation seems correct try with a table having the measure or some grouping of table using values or summarize

example

STDEV_of_last12_week = calculation( STDEVX.P(Table, [CountError]) ,FILTER(ALL('Calendar'),
'Calendar'[WeekID]<=MAX('Calendar'[WeekID]) &&
'Calendar'[WeekID]>=MAX('Calendar'[WeekID])-11 )

[Ortignano]

Thank you Amitchandak, it was my fault:  I didn't use a summarized table.