Standard Deviation

[netanel]

Hey All!

I want to bring my economists analysis of "Standard Deviation"
I have 2 Measure

The daily average:  

[Gross USD AVG] 

and I have Standard Deviation Measure:

Standard Deviation = STDEVX.P(

        VALUES('Date'[Date] ),

        [Gross USD AVG]   )

The problem is I do not know how to look at it in relation to the average
Is it possible to make it 1 and -1 to understand where the company is in relation to the bell?

[Anonymous]

Hi  @netanel ,

Sorry for that the information you have provided is not making the problem clear to me. Are you trying to understand the logic of this function? STDEVX.P function (DAX) - DAX | Microsoft Docs

Best Regards,
Eyelyn Qin

[netanel]

Hey @Anonymous 

Your'e right!
I wrote in a not so clear way
Things have changed a bit
But the story is like that and the question is more statistical
I show the users a standard deviation that is a Simple number? A standard deviation of a particular company is 126,200. Is it correct to show this?
I received feedback from the user that it is difficult to understand when there are several companies and each has a different standard deviation (I know that when the larger the standard deviation is the AVG not stable) but for the user it is not clear
I wanted to know if there is a formula that can put all the standard stays in an area of (-1,1, -2,2, -3,3) as long as the user gets the area where his average is clearly

https://en.wikipedia.org/wiki/Standard_deviation

You can look at the link for the areas marked by numbers -1,1 and more

Thanks!