Calculated Column Comparing Field Value to Measure Showing Incorrect Value

[mendriki32]

So I've added a field comparing a column to a filtered value (measure) in import mode. In all of the columns below _IsCurrentJob should be 1. All the _timeSeriesDateTime fields are not aggregated/summarized in any way. 

Where 

_SelectedJob = SELECTEDVALUE(jobTable[jobNumber])

Now I searched the forums and found a suggestion to turn it into an aggregate measure

_sj2 = IF(max(_timeSeriesDateTime[jobNumber]) = [_SelectedJob],1,0)

which gives me the correct values in table form (tested and correctly showing 0 for non-matching values),

but when I try to filter a date slicer (not the above table) visual based on _sj2 = 1 I get this:

After a lengthy google search and an afternoon spent researching set theory, I'm throwing in the towel. Any and all help would be greatly appreciated. 

[v-cherch-msft]

Hi @mendriki32 

Based on my test,the measure is correct.Please check the visual level filter as attachment.

Regards,

[mendriki32]

@v-cherch-msft Still getting the same error mentioned in the original post. I should have mentioned that the error was thrown from a date slicer visual, with "time" being the only field. I've updated the original question.

[v-cherch-msft · Accepted solution]

Hi @mendriki32 

Please change the time to list mode.Then drag the _sj2 measure to visual level filter.

Regards,