Calculated Column and Measure.

[Anonymous]

Hi Community.

Someone can help me with this issue.

In here I expected measures result should be same column result.

but Columns result is correct, but Measures are not correct. 

Column expression:

duration_days = '00 - Service Order'[duration_seconds]/(3600*24)

duration_hours = '00 - Service Order'[duration_seconds]/3600

Measure expression:

Durations (Days) = SUM('00 - Service Order'[duration_days])

Durations (Hours) = SUM('00 - Service Order'[duration_hours])

Thanks

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, I create a sample, it get the different result with yours, the column and measure get the same value.

I guess it has something to do with the formula of [duration_seconds], in my sample, [duration_seconds] is a calculated column.

duration_seconds =
DATEDIFF (
    '00 - Service Order'[Lag last modified date time],
    '00 - Service Order'[Last Modified Datetime],
    SECOND
)

I also attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this posthelps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

Hi @Anonymous .
SUM will return a summarized total value.
Try to use CALCULATE or SUMX for the same.


Thanks,
Sanket.

If this post helps, then mark it as 'Accept as Solution' and give it a thumbs up.

[Anonymous]

Hi @Anonymous Thanks for your answer, I have tried with SUMX, but result also like that.

Durations (Hours) = SUMX('00 - Service Order','00 - Service Order'[duration_hours])

Durations (Days) = SUMX('00 - Service Order','00 - Service Order'[duration_days])