How to Divide Measure by Constant

[jugisahunk]

Ok, n00b here. My searching is weak so I didn't find anything that satisfied my need.

I have a dataset of work items. I have a lead time column present on each record. It is in minutes, and I want to create a measure that displays lead time in hours. I want that measure to be (in pseudo code):

lead time (hrs) = lead time / 60

I'm finding this difficult to do in DAX. What is your advice?

[Yosi]

It does not work... I have a column of counts and need to divide ach value by a constant - this soln does not work

[v-yulgu-msft · Accepted solution]

Hi @jugisahunk,

Please refer to below measure:

lead time (hrs) = SELECTEDVALUE(Dataset[lead time])/ 60

Best regards,

Yuliana Gu

[jugisahunk]

This gives me what I need :). Unfortunately, I'm getting an error when I try to accept this as a solution.