Forum Discussion

mendriki32's avatar
mendriki32
Frequent Visitor
7 years ago
Solved

Calculated Column Comparing Field Value to Measure Showing Incorrect Value

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. 

3 Replies