Error : A table of multiple values was supplied where a single value was expected.

[chotu27]

Previous SiteRateScore 1 = 
var curSubjectNumber = 'question 1'[SubjectNumber]
var curSequence = 'question 1'[Sequence]
var prevSequence = 
CALCULATE(
    MAX('question 1'[Sequence])
    ,FILTER(ALL('question 1')
        ,'question 1'[SubjectNumber] = curSubjectNumber && 'question 1'[Sequence] < curSequence
    )
)
return
//prevSequence
LOOKUPVALUE('question 1'[SiteRaterScore],'question 1'[SubjectNumber],curSubjectNumber,'question 1'[Sequence],prevSequence

[vanessafvg · Accepted solution]

@chotu27 you are obviously not getting unique results, its bringing back more than one row?