Standard Deviation in DAX Help

Question

I have the following Standard Deviation formula which i calculated using 3 different measures and combining them into one. 

"SQ((SQ(QTY Issued From Store - Daily Rolling Run Rate)
+SQ(QTY Issued From Store - Daily Rolling Run Rate)
+SQ(QTY Issued From Store - Daily Rolling Run Rate)
+SQ(QTY Issued From Store - Daily Rolling Run Rate))
/'User Table'[Table1]')"

1St Measure: QTY Issued From Store - Daily Rolling Run Rate

2nd Measuer: SQ(1St Measure) +SQ(1St Measure) +SQ(1St Measure) +SQ(1St Measure)

3rd measure: SQ((2nd measuer/'user Table'[table1]))

Here the user table is the days table unrelated to fact and dimensions where in user will choose the days of choice and the standard deviaiton will be divided by the number of days choosen.

The problem is that the formula is taking tooo long in order to get calculated. Any help in modifying the abover query helpful. Thanks.

---

Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.

Answer 1

Hi,

Several New DAX Functions were added, these functions were added to calculate the standard deviation of the entire population or a sample (STDEV.S(), STDEV.P(), STDEVX.S(), STDEVX.P()). For more information, see STDEV.S Function (DAX), STDEV.P Function (DAX), STDEVX.S Function (DAX), and STDEVX.P Function (DAX).

Thanks,

---

Challen Fu

TechNet Community Support

Answer 2

hi, please go through the below link. May  be it is helpful for you.

http://erikasblog.datainspirations.com/2010/04/07/a-treatise-on-the-all-function-in-dax-or-is-it-all-er-nuthin-with-you/