Forum Discussion

felipeBI's avatar
felipeBI
Regular Visitor
5 years ago

Problem with standar devuation DAX

Good Morning! I have a problem with the fuction STDEV.S (standar devuation) Data |2| |3| |2| |9| |4| |2| |5| In Excel I use the next formula =DESVEST.M(A1:A7), Result: 2.54483604. In Po...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi felipeBI 

I think your problem lies in ALLSELECTED() .

ALLSELECTED() : Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters. It keeps explicit filters and contexts other than row and column filters. 

So you will include explicit filters and context in your calculations and the result is different from the result that from excel .

I created a sample without any filters and the result is same with the result that from excel .

Column = STDEV.S('Table'[value])

I have attached my pbix file ,you can refer to it .

 

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.