Using STDEVX.P with a custom measure

Question

Hello Everyone, I'm brand new to DAX and i'm trying to calculate SD. Can anyone help me out? Below are the details.&nbsp;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.&nbsp;the table looks like this.&nbsp;&nbsp;Move_time&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp;Crane_ID01:09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15101:15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15101:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12002:09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12002:10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;151&nbsp;I created a custom measure called&nbsp;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.&nbsp;Crane_ID&nbsp; &nbsp; &nbsp;|&nbsp; Count MoveTime151&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 603120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 201&nbsp;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?

owenauger · Accepted Answer

Hi&nbsp;jpurdue&nbsp;
&nbsp;
It sounds like you want the standard deviation of [Count MoveTime] per crane. Is that right?
&nbsp;
If so, you should provide the distinct values of Crane_ID as the first argument, and the [Count MoveTime] measure as the second argument.
&nbsp;
For example:
Standard deviation of Count MoveTime per Crane = 
STDEVX.P (
    VALUES ( table[Crane_ID] ),
    [Count MoveTime]
)
&nbsp;
Regards,
Owen

Forum Discussion

Using STDEVX.P with a custom measure

2 Replies

Related content

Measures vs Custom Columns

Customer Scorecard

Custom Visual

Custom formatting number measure

Measure