Today() Format problem

[learner03]

I have a measure based on TODAY(), which is-

Current Closed Orders = 

CALCULATE (

COUNT( 'Packing Jobs'[JobID] ),

FILTER ( ALLSELECTED('Packing Jobs'), [Job Close Time(Date format)] =TODAY() )

)

This works fine in desktop but when I publish this in service and schedule refresh, I have seen that it doesn't show values till 10:00 am and shows BLANK as I think it takes UTC time for refresh. I am based in Australia. After the 10:00 am refresh it shows values.

To overcome this I have created this offset and trying this for the first time, but it shows below error. What am I doing wrong here?

[wdx223_Daniel · Accepted solution]

test returns a text value, it can not compare with a date value

try add a VALUE in the code of test

VALUE(FORMAT())