topic Re: Using STDEVX.P with a custom measure in DAX Commands and Tips

Using STDEVX.P with a custom measure

jpurdue — Thu, 20 Jan 2022 22:18:10 GMT

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?

Re: Using STDEVX.P with a custom measure

OwenAuger — Fri, 21 Jan 2022 02:44:57 GMT

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

Re: Using STDEVX.P with a custom measure

jpurdue — Fri, 21 Jan 2022 17:13:52 GMT

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