Using STDEVX.P with a custom measure

[jpurdue]

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. The "Move_time" column and the "crane_id" column. The "Move_time" column is in a date format.

the table looks like this. 

Move_time      |     Crane_ID

01:09                     151

01:15                     151

01:30                     120

02:09                     120

02:10                     151

I created a custom measure called Count MoveTime = COUNT(table[Move_time]) that I can use to count how many times each crane moved, so I can recap easily in reports. A recap would look like this.

Crane_ID     |  Count MoveTime

151                        603

120                        201

Since I can't simply run STDEVX.P on the (table[Move_time]) since it's a date, I'm kinda lost. How would I achieve this using the "Count MoveTime" measure?

[jpurdue]

ahh that easy huh? THANKS!!!!!!!!

[OwenAuger · Accepted solution]

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