LOOKUPVALUE gone wild

[MrSQL]

Hi,

I am building out some measures and hit a snag, appreciate any advice. 

• Measure One looks like this: A-Parts Finish = LOOKUPVALUE(Tasks[EndDate],Tasks[KeyMilestoneType],"A-Parts")
  • This works great.
• Mesure Two looks like this: A-Parts Health = LOOKUPVALUE(Tasks[TaskStatus],Tasks[KeyMilestoneType],"A-Parts")
  • This works great
• Measure Three looks like this: A-Parts PercentDone = LOOKUPVALUE(Tasks[PercentDone],Tasks[KeyMilestoneType],"A-Parts")
  • This one throws an error:  A table of multiple values was supplied where a single value was expected

 This doesn't make sense to me, any thoughts?

[MrSQL · Accepted solution]

Found the solution here: https://community.powerbi.com/t5/Desktop/LOOKUPVALUE-quot-A-table-of-multiple-values-was-supplied-wh...