Forum Discussion
Solved
Using STDEVX.P with a custom measure
Hello Everyone, I'm brand new to DAX and i'm trying to calculate SD. Can anyone help me out? Below are the details. I have a dataflow setup from a Database that puts the below columns in a table....
Hi jpurdue
It sounds like you want the standard deviation of [Count MoveTime] per crane. Is that right?
If so, you should provide the distinct values of Crane_ID as the first argument, and the [Count MoveTime] measure as the second argument.
For example:
Standard deviation of Count MoveTime per Crane = STDEVX.P ( VALUES ( table[Crane_ID] ), [Count MoveTime] )Regards,
Owen
OwenAuger
Super User
Super UserHi jpurdue
It sounds like you want the standard deviation of [Count MoveTime] per crane. Is that right?
If so, you should provide the distinct values of Crane_ID as the first argument, and the [Count MoveTime] measure as the second argument.
For example:
Standard deviation of Count MoveTime per Crane =
STDEVX.P (
VALUES ( table[Crane_ID] ),
[Count MoveTime]
)
Regards,
Owen