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
MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi felipeBI ,

 

You issue is related with the context of the ALLSELECTED (check documentation) in this case when you do the all selected you are adding not only the ones that have values but also the ones that have 0, and other values that you are not seeing in filter context.

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.