Dax Measure not showing total in table

[unknown917]

I have a measure to calculate the span of time between 2 timestamps.  I have it categorized as General but have also tried decimal number.  Here is my measure below:

Actual Service = DIVIDE(IF(DATEDIFF(SELECTEDVALUE(Query1[Arrived Time]),SELECTEDVALUE(Query1[Completed Time]),second)=BLANK(),0,DATEDIFF(SELECTEDVALUE(Query1[Arrived Time]),SELECTEDVALUE(Query1[Completed Time]),second)),60,0)

When I add the measure as a column to the table visual, it does not sum the times in totals row.  I added the if statement thinking it was a null issue, but now I get 0.00 instead of nothing.

[AlexisOlson · Accepted solution]

SELECTEDVALUE ( ) is syntax sugar for IF ( HASONEVALUE ( ), VALUES ( ) ). The problem is that you haven't define how this should work when there are multiple times, not just a single one. It looks like you want to sum them.

Try this:

Actual Service =
SUMX (
    Query1,
    DATEDIFF ( Query1[Arrived Time], Query1[Completed Time], SECOND ) / 60
)

[unknown917]

Thank you @AlexisOlson !